用JDBC连接SQLSERVER的问题！一定给分！

[钟伟海]

JDBC的驱动已经装好了，
在JSP中怎样写连接语句呢？（不是用JDBC-ODBC）
能否给个例子看看！

[yanchang]

你忘了说你的驱动名称了
我是用MS的驱动
<%@ page language = "java" %>
<%@ page import = "com.microsoft.*,java.sql.*" %>

<%
Connection conn = null;
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn=DriverManager.getConnection("jdbc:sqlserver://myname:1433;user=sa;password=sa;DatabaseName=mzg");
out.print(conn);
}
catch(Exception e)
{
out.println("Error getConnection Function " + e);
}
%>

[zhjx_10]

String driverClass = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String connectUrl = "jdbc:microsoft:sqlserver://localhost:1433";
String userName = "sa";
String userPass = "sql";
Class.forName(driverClass);
Connection conn = DriverManager.getConnection(connectUrl,userName,userPass);
conn.setCatalog("dbName");
Statement st = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = null;
String sqlStr = "select ..... ";
rs = st.executeQuery(sqlStr);
while ( rs.next() ) {
//do something
}
rs.close();
st.close();

[钟伟海]

显示下列；
com.microsoft.jdbc.sqlserver.SQLServerConnection@3bc20e
是否连接正确？

[钟伟海]

up

[yanchang]

当然！！！