JDBC涓?杞藉??瑁?
![]() ![]() ??ョ????绔? SQL Server 2000 JDBC椹卞?ㄤ?杞? 2009/03/03 10:55 SQL Server 2000 JDBC椹卞?ㄤ?杞? 2008-07-28 15:20 涓???涓?杞?QLSERVER2000??jdbc椹卞?ㄧ?搴??? ?ㄥ井杞?绔??瑰氨??杩?涓?椹卞?ㄧ?搴?锛? Window??浣?绯荤? http://www.uncj.com/upload/files/ms_jdbc_setup.exe http://download.microsoft.com/download/3/0/f/30ff65d3-a84b-4b8a-a570-27366b2271d8/setup.exe Unix??浣?绯荤? Mssqlserver.tar http://download.microsoft.com/download/3/0/f/30ff65d3-a84b-4b8a-a570-27366b2271d8/mssqlserver.tar 浜???瀹?瑁?JDBC ?ц?ms_jdbc_setup.exe???ц???浠讹?涓???????瑕??瑰?讳?涓?姝ワ??冲?板?虹??inish????锛?瀹???瀹?瑁??? 娉?? (1) ms_JDBC_setup榛?璁ゅ??瑁?璺?寰?涓猴?c:/Program Files/Microsoft SQL Server 2000 Driver for JDBC (2)姝ょ??(Version 2.2.0022)??浠?????Microsoft SQL Server 2000 Driver for JDBC (3)瀹?瑁???褰?/lib/涓???涓?涓?jar??浠跺?虫????浠?瑕???JDBC椹卞?ㄦ?稿? msbase.jar mssqlserver.jar msutil.jar 涓???灏?浠ヤ?锛?3锛?涓?????涓?涓?jar??浠跺???ュ?扮??澧?????涓??? classpath锛? d:/webserver/lib/msbase.jar;d:/webserver/lib/mssqlserver.jar;d:/webserver/lib/msutil.jar 娉??涔???浠ョ??浜???灏?浠ヤ?涓?涓???浠舵?疯??充???jvm?烘???ㄧ??JAVA_HOME/jre/lib/ext??褰?涓?锛?涓?杩?涓?寤鸿??杩?涔????? ????娴?璇? jsp??浠讹? <%@ page contentType="text/html;charset=gb2312"%> <%@ page import="java.sql.*"%> <html> <body> <% Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=haiguan"; String user="sa"; String password=""; Connection conn= DriverManager.getConnection(url,user,password); Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); String sql="select * from xt_user"; ResultSet rs=stmt.executeQuery(sql); while(rs.next()) { %> ?ㄧ??绗?涓?涓?瀛?娈靛??瀹逛负锛?<%=rs.getString(1)%> ?ㄧ??绗?浜?涓?瀛?娈靛??瀹逛负锛?<%=rs.getString(2)%> <% } %> <%out.print("?版??搴???浣?????锛?????浣?");%> <% rs.close(); stmt.close(); conn.close(); %> </body> </html> 浜???娉ㄦ??浜?椤? 1. 瑕?淇?璇?浣???Sql???℃?????ㄧ?舵?? 2. ??ql ??绠$???ㄤ腑?藉?浣跨??a???跺???ㄦ?锋?e父?诲?锛?(??浜?浜哄?ㄥ??瑁?sql?剁?ㄤ?nt?ㄦ?风?$??妯″?锛?杩??????戒???涓?瀹???棰?) 3. 绗?涓?娆¢??缃?濂界??澧???????濂借?介????涓?涓??佃?? 4. 娉ㄦ??JVM??DataBase?????ㄩ『搴?锛???????ataBase锛???????VM?恒?? 娉???ㄥ??姝?eb???″?ㄥ??锛??????????涓??存??濂借?芥??10绉?浠ヤ????撮???? 5. 娉ㄦ????浣?绯荤???缃?缁?杩????? A.???ㄤ?Tcp/IP???? B.??缃?浜??稿??P?板??,??浜?浜烘?哄?ㄥ???界?ㄧ???????ㄥ????IP??????缃?IP?讹?浣?缃?缁?涓??????戒??句???P 6. ??浜??哄?ㄥ?ㄨ?璇?????濂借?藉?锛???锛?涓???杩??ュ?板??localhost?规???版??搴????″?ㄧ??IP,杩?涔???瑕?娉ㄦ??5?????? |