?在方法中如何连接数据库?
DJMPH 2002-10-16 02:13:48 <%!
public void exeSQL(String sqlStr) {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url1="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test";
String user1="sa";
String password1="1516";
Connection conn1= DriverManager.getConnection(url1,user1,password1);
Statement stmt1=conn1.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
//String sql1="select id,name from word";
ResultSet rs1=stmt1.executeQuery(sqlStr);
}
%>
为什么不行?