Java program calls the MySQL database instance code

1. Import java. SQL. Connection;
2. Import java. SQL. DriverManager;
3. Import java. SQL. PreparedStatement;
4. Import java. SQL. ResultSet;
6. Public class MySQLTest {
8. Public static void main (String [] args ){
9. // TODO Auto-generated method stub
10. Connection conn = null;
11. Try
12. {
13. String userName = "username ";
14. String password = "password ";
15. String url = "jdbc: mysql: // localhost/test ";
16. Class. forName ("com. mysql. jdbc. Driver"). newInstance ();
17. Conn = DriverManager. getConnection (url, userName, password );
18. System. out. println ("Database connection established ");
19. PreparedStatement pstmt;
20. ResultSet rset;
21. Pstmt = conn. prepareStatement ("select count (*) from testtable ");
22. Rsetaskpstmt.exe cuteQuery ();
23. While (rset. next ()){
24. System. out. println (rset. getString (1); // Print col 1
25. }
26. }
27. Catch (Exception e)
28. {
29. System. err. println ("Cannot connect to database server ");
30. }
31. Finally
32. {
33. If (conn! = Null)
34. {
35. Try
36. {
37. Conn. close ();
38. System. out. println ("Database connection terminated ");
39. }
40. Catch (Exception e) {/* ignore close errors */}
41. }
42. }
43. }
44. }