connectdb.jsp

来自「新闻发布系统源代码 可以作为网站的模板」· JSP 代码 · 共 14 行

   

  <%
	Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
	String url="jdbc:microsoft:sqlserver://localhost:1433;databaseName=news";
	Connection con= DriverManager.getConnection(url,"sa","123456");
	
	Statement smt1 = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
	Statement smt2 = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
	ResultSet rs1,rs2;
	String sql1,sql2;

%>