7.9w+
社区成员
- 主页
用JDBC连接SQLSERVER的问题！一定给分！
JDBC的驱动已经装好了，
在JSP中怎样写连接语句呢？（不是用JDBC-ODBC）
能否给个例子看看！
在JSP中怎样写连接语句呢？（不是用JDBC-ODBC）
能否给个例子看看！
...全文
请发表友善的回复…
发表回复
yanchang 2002-02-27
当然！！！
钟伟海 2002-02-27
up
钟伟海 2002-02-27
显示下列；
com.microsoft.jdbc.sqlserver.SQLServerConnection@3bc20e
是否连接正确？
com.microsoft.jdbc.sqlserver.SQLServerConnection@3bc20e
是否连接正确？
zhjx_10 2002-02-27
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();
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();
yanchang 2002-02-27
你忘了说你的驱动名称了
我是用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);
}
%>
我是用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);
}
%>