安裝完“SQLFORJDBCSP1.exe"C:/Program?? Files/Microsoft?? SQL?? Server?? 2000?? Driver?? for?? JDBC/lib有“msbase.jar”“mssqlserver.jar”“msutil.jar”?? 三個(gè)文件我把他們都拷貝到“C:/Program?? Files/Apache?? Software?? Foundation/Tomcat?? 5.5/common/lib”下面去了。也把?? 他們分別加到CLASSPATH里C:/Program?? Files/Microsoft?? SQL?? Server?? 2000?? Driver?? for?? JDBC/lib/msbase.jar;C:/Program?? Files/Microsoft?? SQL?? Server?? 2000?? Driver?? for?? JDBC/lib/mssqlserver.jar;C:/Program?? Files/Microsoft?? SQL?? Server?? 2000?? Driver?? for?? JDBC/lib/msutil.jar??
?重新啟動(dòng)Tomcat！??
?寫個(gè)sql?? 測試的sql_test.jsp?? 文件?? 內(nèi)容如下<%@?? page?? contentType="text/html;charset=GB2312"?? %><%@?? page?? import="java.sql.*"?? %>??
??? <%?? Connection?? con;??
????????? Statement?? sql;????
????????? ResultSet?? rs;??
????????? try??
????????? {??
????????????? Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");??
????????? }??
????????? catch(ClassNotFoundException?? e)??
????????? {??
????????????? out.print("類找不到！");??
????????? }??
????????? try????
????????? {??????
??????????????????? con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testDatabse","sa","sa");??
??????????????????? sql=con.createStatement();??
??????????????????? rs=sql.executeQuery("SELECT?? *?? FROM?? userTable");??
??????????????????? out.print("");??
??????????????????? out.print("用戶數(shù)據(jù)");????????
??????????????????? out.print("");??
????????????????????????? out.print(""+"用戶ID號(hào)");??
????????????????????????? out.print(""+"用戶名");??
????????????????????????? out.print(""+"用戶真實(shí)姓名");??
????????????????????????? out.print(""+"年齡");??
????????????????????????? out.print(""+"性別");??
????????????????????????? out.print(""+"聯(lián)系地址");??
????????????????????????? out.print(""+"聯(lián)系電話");??
????????????????????????? out.print(""+"添加時(shí)間");??
??????????????????? out.print("");??
??????????????? while(rs.next())??
??????????????? {?? out.print("");??
??????????????????????????? out.print(""+rs.getLong(1)+"");??
??????????????????????????? out.print(""+rs.getString(2)+"");????
??????????????????????????? out.print(""+rs.getString(4)+"");??
??????????????????????????? out.print(""+rs.getInt("user_age")+"");????
??????????????????????????? out.print(""+rs.getString("user_sex")+"");??
??????????????????????????? out.print(""+rs.getString("user_address")+"");??
??????????????????????????? out.print(""+rs.getString("user_telephone")+"");??
??????????????????????????? out.print(""+rs.getString("add_time")+"");??
????????????????? out.print("")?? ;????
????????????????? }??
????????????????? out.print("");??
????????????????? con.close();??
??????????? }??
??????? catch(SQLException?? e1)????
??????? {??
????????????? out.print("SQL異常！");??
??????? }??
??? %>??
?保存完放在??C:/Program?? Files/Apache?? Software?? Foundation/Tomcat?? 5.5/webapps/ROOT這里?? 然后??打開ie?? 輸入http://localhost:8080/sql_test.jsp