JDBC连接数据库的6个步骤

//1、加载驱动
Class.forName("com.mysql.jdbc.Driver");

//2、获得数据库连接
String url = "jdbc:mysql://localhost:3306/tyut_test2";
String username = "root";
String password = "root";
Connection con = DriverManager.getConnection(url, username, password);

//3、获得Statement或者PreparedStatement对象
String sql = "select * from user where FirstName=?";
String sql2 = "insert/delete/update...";

Statement stmt = con.createStatement();
PreparedStatement ps = con.prepareStatement(sql);

//4、执行sql语句
ResultSet rs = stmt.executeQuery(sql);
int rows = stmt.executeUpdate(sql2);

ps.setString(1, "zhang");
ResultSet rs = ps.executeQuery();
int rows = ps.executeUpdate();

//5、分析结果
while(rs.next()){
    //loop the table
    int id = rs.getInt("UserId");
    //int id = rs.getInt(1);
    String email = rs.getString("Email");
}

//6、释放资源
rs.close();
stmt.close();
con.close();