8.0w+
社区成员
那位有關於SERVLET操作數據庫的例子﹐給一個﹐有高分重獎﹗
那位有關於SERVLET操作數據庫的例子﹐給一個﹐有高分重獎﹗
就事一般的用表單提交數據的例子﹐要用SERVLET1
就事一般的用表單提交數據的例子﹐要用SERVLET1
...全文
当前发帖距今超过3年，不再开放新的回复
发表回复
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>");
}
}
试试看吧！给我加分喔！
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
一样的写代码，没有什么特别的
「风险评估」支持国产密码算法的OpenSSL设计实现及应用 - 金融安全.zip 「风险评估」支持国产密码算法的OpenSSL设计实现及应用 - 金融安全
WAF
基础架构安全
WAF
网络安全
APT
kernel-plus-headers-3.10.0-1160.6.1.el7.centos.plus.x86_64.rpm kernel-plus-headers-3.10.0-1160.6.1.el7.centos.plus.x86_64.rpm
