IDEA操作jdbcまとめ

今日IDEA操作JDBCを勉強して、MySQLパッケージはプロジェクトに導入します

// 1、        
//        Driver driver=new com.mysql.jdbc.Driver();
//        DriverManager.registerDriver(driver);
        String driver = "com.mysql.jdbc.Driver";
 Class.forName(driver);//java    

 // 2.       

 String url = "jdbc:mysql://localhost:3306/fresh";
 Connection connection = DriverManager.getConnection(url, "root", "");

 //3.          
 Statement statement = connection.createStatement();
 String sql = "select * from user";
 ResultSet resultSet = statement.executeQuery(sql);

 //4.     ，    
 while (resultSet.next()){
 String name = resultSet.getString("name");
 System.out.print("  ："+name);
 }
 connection.close();

//    
String sql = "UPDATE user set name='  ' where id=1";
int resule = statement.executeUpdate(sql);

System.out.println(resule);

statement.close();
connection.close();


Junit     
  =》  test   ，project structure=>  test    sources     test      java  

転載先:https://www.cnblogs.com/smartwen666/p/8320658.html