Question

如何解决SQL SERVER2005本地无法连接的问题

Answer 1

import java.sql.*; import java.net.*; public class sqltry { public static void main (String[] args) { String sDBDriver="com.microsoft.sqlserver.jdbc.SQLServerDriver"; String dbURL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test;user=lysander;password="; Connection dbconn=null; try { Class.forName(sDBDriver); dbconn=DriverManager.getConnection(dbURL); System.out.println("Connection Successful!"); sqltry.executeUpdateStatement(dbconn); } catch (Exception e) { e.printStackTrace(); } } public static void executeUpdateStatement(Connection con) { try { String SQL = "SELECT * FROM [test].[dbo].[学校代码表] ORDER BY 最低分数"; String SQL2 ="INSERT INTO [test].[dbo].[学校代码表]([学校代码],[学校名],[招生人数],[最低分数]) VALUES (001,ybo1,2000,469)"; Statement stmt = con.createStatement(); int count = stmt.executeUpdate(SQL2); //关了Statement stmt.close(); System.out.println("use test datebase "+"ROWS AFFECTED: " + count); //再建一Statement,下边的ResultSet用这个得到 Statement st = con.createStatement(); ResultSet rs = st.executeQuery(SQL); while(rs.next()) { System.out.println(rs.getString("学校名") + ", " + rs.getString("学校代码")); } //关闭后来建的Statement st.close(); rs.close(); } catch (Exception e) {e.printStackTrace();} } //public sqltry() //{ //} }