那位有關於SERVLET操作數據庫的例子﹐給一個﹐有高分重獎﹗

sunny666 2001-11-14 06:43:17

那位有關於SERVLET操作數據庫的例子﹐給一個﹐有高分重獎﹗
就事一般的用表單提交數據的例子﹐要用SERVLET1

...全文

78 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

ice_girl 2001-11-14

打赏
举报

import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.io.*;

public class testconnect extends HttpServlet{
Connection conn;

public void init(ServletConfig conf) throws ServletException
{
try{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
conn=DriverManager.getConnection("jdbc:oracle:thin:@hostname:1526:orc1","username","password");
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//conn=DriverManager.getConnection("jdbc:odbc:database","username","password");//使用jdbc.odbc连接
}catch(Exception e){
System.out.println("database doesn't connect");
}

}
public void service(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException
{
res.setContentType("text/html");
ServletOutputStream out=res.getOutputStream();
out.println("<html><body>");
try{
Statement stmt=conn.createStatement();
ResultSet rset=stmt.executeQuery("select * from dm_kc");
while(rset.next()){
String str=rset.getString(1);
out.println(str);
}
stmt.close();
conn.close();
}
catch (Exception e) {out.println("aaa");}
out.println("rrrrr");
out.println("</body></html>");
}
}
试试看吧！给我加分喔！

wyzegg 2001-11-14