Java操作mysql 数据库

package comparejsonandmysql;

import java.sql.*;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.*;


public class MysqlTest {
    public static void main(String[] args) {
        String driver = "com.mysql.jdbc.Driver";
        String url = "jdbc:mysql://127.0.0.1:3306/phpwind";
        String user = "root";
        String passwd = "123456";
        int i = 1;
        try {
            Class.forName(driver);
            Connection conn = DriverManager.getConnection(url,user,passwd);
            if(!conn.isClosed()) {
                System.out.println("Succeed Connected!");
                String query = "select * from pw_acloud_apis";
                Statement statement = conn.createStatement();
                ResultSet rs = statement.executeQuery(query);
                System.out.println("------------------------");
                System.out.println("执行结果如下");
                System.out.println("------------------------");
                while(rs.next()) {
                    System.out.print(rs.getInt(1) +"	");//列数是从 1 开始
                    System.out.println(rs.getString(2));
                }
                //更新表数据
                String creaDate = "20171212";
                String modiDate = "20171213";
                SimpleDateFormat sdf = new  SimpleDateFormat("yyyymmdd");
                
                String pQuery = "insert into pw_acloud_app_configs(app_id, app_key, app_value, app_type, created_time, modified_time)" + "values(?,?,?,?,?,?)";
                PreparedStatement pstment = conn.prepareStatement(pQuery);
                pstment.setInt(1, 3);
                pstment.setString(2, "key1");
                pstment.setString(3, "hello world!");
                pstment.setInt(4, 1);
                pstment.setLong(5, sdf.parse(creaDate).getTime());
                pstment.setLong(6, sdf.parse(modiDate).getTime());
                pstment.executeUpdate();
                System.out.println("inserted done!");
                
                //删除表数据：
                String pDel = "Delete from pw_acloud_apis where id = ?";
                PreparedStatement ps = conn.prepareStatement(pDel);
                ps.setInt(1, 2);
                ps.executeUpdate();
                System.out.println("Delete Done!");
                rs.close();
                statement.close();
                conn.close();
            }
            
    
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            System.out.println("JDBC Drive not found!");
            e.printStackTrace();
        }catch (SQLException e) {
            // TODO Auto-generated catch block
            System.out.println("Fail to connect!");
            e.printStackTrace();
        } catch (ParseException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
}