java简单的数据库查询（SQLServer数据库）

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 }

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 }

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