java连接sqlserver代码,Java连接sql server代码，javasqlserver代码,java连接sqlser

Java连接sql server代码，javasqlserver代码,java连接sqlser

java连接sqlserver代码：Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //1. Register your driver//2. get the connection object//Connection con = DriverManager.getConnection("jdbc:sqlserver://localhost;databaseName=aysha","sa","admin");Connection con = DriverManager.getConnection("jdbc:sqlserver://127.0.0.1;databaseName=aysha","user=sa","password=admin"); //"jdbc:sqlserver://127.0.0.1:1433; Instance=SQL2008;" + "databaseName=MB;user=sa;password=123;";//Connection con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=aysha","sa" , "password");//3. Prepare a statementStatement stmt = con.createStatement();//4. Write the query`String sql = "Select * from employee";//5. Execute the statement and ResultSet rs = stmt.executeQuery(sql);//6. Process the result setwhile (rs.next()){ System.out.println(rs.getInt(1));}

需要引用sqlserver驱动jar包，或者在maven中引用一下依赖：com.hynnetsqljdbc4-chs4.0.2206.100