1.数据库链接类

1 import java.sql.Connection; 2 import java.sql.DriverManager; 3 import java.sql.SQLException; 4  5 public class DBHelper { 6     /** 7      * 获取数据库链接 8      *  9      * @return 数据库链接10      */11     public static Connection getConnection() {12         Connection conn = null;13         String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";// 驱动14         String username = "sa";// 用户名15         String password = "sa";// 密码16         String url = "jdbc:sqlserver://192.168.1.10;DatabaseName=test";// SqlServer链接地址17         try {18             Class.forName(driver);//加载驱动类19             conn = DriverManager.getConnection(url, username, password);20         } catch (ClassNotFoundException e) {21             System.out.println("找不到驱动程序类 ，加载驱动失败！");22             e.printStackTrace();23         } catch (SQLException e) {24             System.out.println("数据库连接失败！");25             e.printStackTrace();26         }27         return conn;28     }29 30 }

2.执行查询

1 import java.sql.Connection; 2 import java.sql.PreparedStatement; 3 import java.sql.ResultSet; 4 import java.sql.SQLException; 5  6 public class TestQuery { 7  8     public static void main(String[] args) { 9         Connection conn = DBHelper.getConnection();// 获取数据库链接10         PreparedStatement ps = null;11         ResultSet rs = null;12         try {13             String sql = "select * from users";14             ps = conn.prepareStatement(sql);15             rs = ps.executeQuery();// 执行查询16             while (rs.next()) {
   // 判断是否还有下一个数据17                 System.out.println("ID:" + rs.getString("id") + "\tNAME:"18                         + rs.getString("name"));19             }20         } catch (SQLException e) {21             e.printStackTrace();22         } finally {23             if (rs != null) {24                 try {25                     rs.close();// 关闭记录集26                 } catch (SQLException e) {27                     e.printStackTrace();28                 }29             }30             if (ps != null) {31                 try {32                     ps.close();// 关闭声明33                 } catch (SQLException e) {34                     e.printStackTrace();35                 }36             }37             if (conn != null) {38                 try {39                     conn.close();// 关闭连接40                 } catch (SQLException e) {41                     e.printStackTrace();42                 }43             }44         }45 46     }47 48 }

3.执行结果

ID:00027c20dad4467180be4637d1f6008f    NAME:张三ID:0c99ddbeba304596ae87f34cfb1e21f7    NAME:李四