JDBC理解

JDBC的步骤
1.加载驱动
Class.forName("com.mysql.jdbc.Driver");
2.获取连接：
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/数据库名","root","root");
3.执行sql语句
Statement st=conn.createStatement();
//执行查询
ResultSet rs=st.executeQuery(sql);
while(rs.next()){
rs.getInt();
rs.getString();
}
if(rs.next()){
rs.getInt();
rs.getString();
}
//执行增删改
int rows=st.executeUpdate(sql);
if(rows>0){
//成功
}