Guest User

Untitled

a guest
Dec 1st, 2017
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.04 KB | None | 0 0
  1. package JDBC;
  2.  
  3. import java.sql.*;
  4.  
  5. public class JDBCDemo6 {
  6.  
  7. private static String user = "vagrant";
  8. private static String password = "vagrant";
  9.  
  10. public static void main(String[] args) throws Exception {
  11. try {
  12. //加载驱动程序
  13. Class.forName("com.mysql.jdbc.Driver");
  14. System.out.println("加载驱动成功");
  15. } catch (ClassNotFoundException e) {
  16. System.out.println("加载驱动失败");
  17. e.printStackTrace();
  18. }
  19.  
  20. //JDBC的URL
  21. String url = "jdbc:mysql://127.0.0.1:33060/mydb";
  22. Connection connection = null;
  23.  
  24. try {
  25. //调用DriverManager对象的getConnection()方法,获得一个Connection对象
  26. connection = DriverManager.getConnection(url, user, password);
  27. Statement state = connection.createStatement();
  28. System.out.println("连接成功");
  29. String sql = "SELECT * from customer";
  30.  
  31. boolean hasResultSet = state.execute(sql);
  32. // 如果执行后有ResultSet结果集
  33. if (hasResultSet)
  34. {
  35. // 获取结果集
  36. ResultSet rs = state.getResultSet();
  37. // ResultSetMetaData是用于分析结果集的元数据接口
  38. ResultSetMetaData rsmd = rs.getMetaData();
  39. int columnCount = rsmd.getColumnCount();
  40. // 迭代输出ResultSet对象
  41. while (rs.next())
  42. {
  43. // 依次输出每列的值
  44. for (int i = 0 ; i < columnCount ; i++ )
  45. {
  46. System.out.println(rs.getString(i + 1));
  47. }
  48. System.out.print("\n");
  49. }
  50. }
  51. else
  52. {
  53. System.out.println("该SQL语句影响的记录有" + state.getUpdateCount() + "条");
  54. }
  55.  
  56. state.close();
  57. connection.close();
  58. } catch (SQLException e) {
  59. e.printStackTrace();
  60. }
  61. }
  62. }
Add Comment
Please, Sign In to add comment