conn.jsp

来自「jsp+sql论坛系统 jsp+sql论坛系统 jsp+sql论坛系统」· JSP 代码 · 共 16 行

<%
     //java.sql.Connection conn;
     //java.sql.Statement stmt;
     //java.sql.ResultSet rs;
     //Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
     //String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bbs";
     //String user="sa";
     //String password="";
     //conn=DriverManager.getConnection(url,user,password);
     //stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance(); 
String url="jdbc:jtds:sqlserver://localhost:1433/bbs;USER=sa;PASSWORD="; 

Connection conn= DriverManager.getConnection(url); 
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); 
%>