Java语言JDBC数据库连接操作

Love The Way You Lie 2022-07-15 06:24 185阅读 0赞

**\[java\]** [view plain][] [copy][view plain]

[print][view plain] [?][view plain]

1.  **public****class** MyJDBC \{ 
2.  
3.  **public****static****void** main(String\[\] args) \{ 
4.  
5.  
6.  // 数据库JDBC驱动地址
7.   String driverManageString = **null**; 
8.  // 数据库连接地址
9.   String url = **null**; 
10. // 数据连接密码
11.  String password = **null**; 
12. // 数据库连接用户名
13.  String user = **null**; 
14. 
15. **try** \{ 
16. 
17. 
18. // 加载数据库JDBC连接恭驱动
19.  Class.forName(driverManageString); 
20. 
21. 
22. 
23. // 创建数据库连接
24.  Connection connection = DriverManager.getConnection(url, user, password); 
25. 
26. // 创建一个执行SQL语句的工具接口
27.  Statement stmt = connection.createStatement(); 
28. 
29.  ResultSet rs = stmt.executeQuery(" select id, name, pwd from custmer"); 
30. 
31. //获取查询出的数据
32. **while** (rs.next()) \{ 
33. 
34.  System.out.println(rs.getObject(1)); 
35. 
36.  \} 
37. 
38. // 创建一个预编译的SQL语句工具接口
39.  PreparedStatement pstmt = connection.prepareStatement(" select id, name, pwd from custmer where id = ?"); 
40.  pstmt.setObject(0, **new** Object()); 
41. 
42. // 结果集，返回SQL查询后生成的一张数据表
43.  ResultSet prs = pstmt.executeQuery(); 
44. 
45. **while** (prs.next()) \{ 
46. 
47.  System.out.println(rs.getObject(1)); 
48. 
49.  \} 
50. 
51.  connection.close(); 
52. 
53.  rs = **null**; 
54. 
55.  prs = **null**; 
56. 
57.  \} 
58. **catch** (ClassNotFoundException e) \{ 
59. 
60.  e.printStackTrace(); 
61.  \} 
62. **catch** (SQLException e) \{ 
63. 
64.  e.printStackTrace(); 
65.  \} 
66. 
67.  \} 
68. 
69. \} 
70.

[view plain]: http://blog.csdn.net/itpinpai/article/details/8764301#