云萌主云应用官方论坛

标题: JAVA mysql数据库连接 [打印本页]
作者: lady-niuniu    时间: 2017-1-10 11:56
标题: JAVA mysql数据库连接
来源：http://www.open-open.com/code/view/1454633126620

  1. package learn;


  4. import java.sql.Connection;

  6. import java.sql.DriverManager;

  8. import java.sql.SQLException;

  10. import java.sql.Statement;

  12. import java.sql.ResultSet;


  15. public class Example01 {



  19. public static void main(String[] args) {

  21. // TODO Auto-generated method stub

  23. String URL="jdbc:mysql://127.0.0.1:3306/test1";

  25. String DRIVER="com.mysql.jdbc.Driver";

  27. String USERNAME="root";

  29. String PASSWD="123456";

  31. String sql;


  34. Connection connection =null;


  37. try{

  39. Class.forName(DRIVER);

  41. connection=DriverManager.getConnection(URL,USERNAME,PASSWD);

  43. Statement stmt = connection.createStatement();

  45. sql = "select * from t1";

  47. ResultSet rs=stmt.executeQuery(sql);

  49. while(rs.next()){

  51. System.out.println(rs.getInt(1)+" "+rs.getString(2)+" "+rs.getString(3));

  53. }

  55. }catch(SQLException e){

  57. System.out.println("test1");

  59. e.printStackTrace();

  61. }catch(ClassNotFoundException e){

  63. System.out.println("test2");

  65. e.printStackTrace();

  67. }finally{

  69. try{

  71. connection.close();

  73. }catch(SQLException e){

  75. System.out.println("test3");

  77. e.printStackTrace();

  79. }

  81. }

  83. }


  86. }

复制代码






欢迎光临 云萌主云应用官方论坛 (https://yunmengzhu.com/) Powered by Discuz! X3.4