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"); } }