import java.sql.*;

public class connectDBTest {

    public static void main(String[] args){
      Connection conn = null;//数据库的连接对象
      Statement stmt = null;//不带参数的语句执行对象
      PreparedStatement pstmt = null;//带参数的语句执行对象
      ResultSet rs = null;//结果集对象
      try{
      //实例化数据库连接驱动类
      Class.forName("com.mysql.jdbc.Driver");
      //获取一个数据库的连接（参数为数据库的链接）
      String url = "jdbc:mysql://localhost:3306/test?user=root&password=11111111";
      conn = DriverManager.getConnection(url);
      //从连接中获取一个语句执行对象（带参数的）
      pstmt = conn.prepareStatement("insert into person values(?,?)");
      pstmt.setInt(1, 4);
      pstmt.setString(2, "xiaoxiao");
      pstmt.executeUpdate();
      //从连接中获取一个语句执行对象（不带参数的）
      stmt = conn.createStatement();
      rs = stmt.executeQuery("select * from person");
      while(rs.next()){
    System.out.print(rs.getString("id"));
    System.out.println(rs.getString("name"));
      }
  } catch (ClassNotFoundException e){
      e.printStackTrace();
  } catch (SQLException e){
      e.printStackTrace();
  }finally{
      try{
    if(rs != null){
        rs.close();
        rs = null;
    }
    if(pstmt != null){
        pstmt.close();
        pstmt = null;
    }
    if(stmt != null){
        stmt.close();
        stmt = null;
    }
    if(conn != null){
        conn.close();
        conn = null;
    }
      } catch (SQLException e){
    e.printStackTrace();
      }
  }
    }
}