JAVA JDBC连接 SQLServer2012

import java.sql.*;

public class ConManager {
    final static String cfn = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
    final static String url = "jdbc:sqlserver://localhost:1433;DatabaseName=test";
    
    public static void main(String[] args) {
        Connection con = null;
        PreparedStatement statement = null;
        ResultSet res = null;
        try {
            Class.forName(cfn);
            con = DriverManager.getConnection(url,"sa","sa");
            
            String sql = "select *from student";//查询test表
            statement = con.prepareStatement(sql);
            res = statement.executeQuery();
            while(res.next()){
                String title = res.getString("sname");//获取test_name列的元素                                                                                                                                                    ;
                System.out.println("姓名："+title);
            }
            
        } catch (Exception e) {
            // TODO: handle exception
            e.printStackTrace();
        }finally{
            try {
                if(res != null) res.close();
                if(statement != null) statement.close();
                if(con != null) con.close();
            } catch (Exception e2) {
                // TODO: handle exception
                e2.printStackTrace();
            }
        }
    }
}

 

 

连接数据库的java测试代码

 1 import java.sql.*;
 2 
 3 public class ConManager {
 4     final static String cfn = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
 5     final static String url = "jdbc:sqlserver://localhost:1433;DatabaseName=student";
 6     
 7     public static void main(String[] args) {
 8         Connection con = null;
 9         PreparedStatement statement = null;
10         ResultSet res = null;
11         try {
12             Class.forName(cfn);
13             con = DriverManager.getConnection(url,"sa","1234");
14             
15             String sql = "select *from test";//查询test表
16             statement = con.prepareStatement(sql);
17             res = statement.executeQuery();
18             while(res.next()){
19                 String title = res.getString("test_name");//获取test_name列的元素                                                                                                                                                    ;
20                 System.out.println("姓名："+title);
21             }
22             
23         } catch (Exception e) {
24             // TODO: handle exception
25             e.printStackTrace();
26         }finally{
27             try {
28                 if(res != null) res.close();
29                 if(statement != null) statement.close();
30                 if(con != null) con.close();
31             } catch (Exception e2) {
32                 // TODO: handle exception
33                 e2.printStackTrace();
34             }
35         }
36     }
37 }

要在java项目中导入sqljdbc4.jar包

项目名鼠标右键->Build Path->Configure Build Path

添加sqljdbc4.jar

添加成功

接下来就是处理SQLServer2012数据库

1.保证服务正常启动

2.保证在数据库中有这些

运行java项目

数据库连接成功！！！