当前位置：首页 -> AI编程基础 -> JAVA

Java程序调用MySQL数据库实例代码

2014-11-23 23:31:31 · 作者: · 浏览: 0
标签: Java 程序 调用 MySQL 数据库 实例 代码
  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. rset=pstmt.executeQuery();
  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. }