JAVA mysql数据库连接

来源：http://www.open-open.com/code/view/1454633126620

1. package learn;
   
2. 
   
3. 
   
4. import java.sql.Connection;
   
5. 
   
6. import java.sql.DriverManager;
   
7. 
   
8. import java.sql.SQLException;
   
9. 
   
10. import java.sql.Statement;
    
11. 
    
12. import java.sql.ResultSet;
    
13. 
    
14. 
    
15. public class Example01 {
    
16. 
    
17. 
    
18. 
    
19. public static void main(String[] args) {
    
20. 
    
21. // TODO Auto-generated method stub
    
22. 
    
23. String URL="jdbc:mysql://127.0.0.1:3306/test1";
    
24. 
    
25. String DRIVER="com.mysql.jdbc.Driver";
    
26. 
    
27. String USERNAME="root";
    
28. 
    
29. String PASSWD="123456";
    
30. 
    
31. String sql;
    
32. 
    
33. 
    
34. Connection connection =null;
    
35. 
    
36. 
    
37. try{
    
38. 
    
39. Class.forName(DRIVER);
    
40. 
    
41. connection=DriverManager.getConnection(URL,USERNAME,PASSWD);
    
42. 
    
43. Statement stmt = connection.createStatement();
    
44. 
    
45. sql = "select * from t1";
    
46. 
    
47. ResultSet rs=stmt.executeQuery(sql);
    
48. 
    
49. while(rs.next()){
    
50. 
    
51. System.out.println(rs.getInt(1)+" "+rs.getString(2)+" "+rs.getString(3));
    
52. 
    
53. }
    
54. 
    
55. }catch(SQLException e){
    
56. 
    
57. System.out.println("test1");
    
58. 
    
59. e.printStackTrace();
    
60. 
    
61. }catch(ClassNotFoundException e){
    
62. 
    
63. System.out.println("test2");
    
64. 
    
65. e.printStackTrace();
    
66. 
    
67. }finally{
    
68. 
    
69. try{
    
70. 
    
71. connection.close();
    
72. 
    
73. }catch(SQLException e){
    
74. 
    
75. System.out.println("test3");
    
76. 
    
77. e.printStackTrace();
    
78. 
    
79. }
    
80. 
    
81. }
    
82. 
    
83. }
    
84. 
    
85. 
    
86. }
    
87. 
    

复制代码