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中引用一下依赖：

        <dependency>            <groupId>com.hynnet</groupId>            <artifactId>sqljdbc4-chs</artifactId>            <version>4.0.2206.100</version>        </dependency>