1、写sql语句
2、查询和新增
3、修改和删除
全部代码（注释部分为查询和新增）
package wwww;
import java.sql.*;
public class sjk2 {
static Connection conn;
static PreparedStatement pstat;
static ResultSet resultSet;
public static void main(String[] args) throws Exception {
getconn();
String updatesql="update info set tel=? where id=?";
String sql="update info set name=? where id=?";
String deletesql="delete from info where id=?";
Object[] obj={"12345678901","5"};
Object[] obj1={"大帅哥","10"};
Object[] delete={"3"};
//String selectsql = "select * from info where sex=?";
// String sql = "update info set name=? where id =?";
//Object[] obj1 = {"男"};
//Object[] obj = {"六六", "7"};
operat(updatesql, obj);
//select(selectsql, obj1);
//sjk2next();
sjk2close();
}
private static void select(String selectsql, Object[] obj1) throws SQLException {
pstat = conn.prepareCall(selectsql);//sql语句有参数变化就要用这个
for (int i = 0; i < obj1.length; i++) {
pstat.setObject(i + 1, obj1[i]);
}
resultSet = pstat.executeQuery();
}
private static void sjk2next() throws SQLException {
while (resultSet.next()) {
System.out.println("id=" + resultSet.getString("id") + "name=" + resultSet.getString("name") + "tel=" + resultSet.getString("tel") + "sex=" + resultSet.getString("sex"));
}
}
private static void sjk2close() throws SQLException {
//resultSet.close();
pstat.close();
conn.close();
}
private static void operat(String sql, Object[] obj) throws SQLException {
pstat = conn.prepareStatement(sql);//sql语句有参数变化就要用这个
for (int i = 0; i < obj.length; i++) {
pstat.setObject(i + 1, obj[i]);
}
pstat.executeUpdate();
}
private static void getconn() throws Exception {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql:///phone_book?useSSL=false", "root", "123456");
}
}
