import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
public class crud{
//增删改查
public ArrayList<EMP> crud(String sql) {
ArrayList<EMP> arr = new ArrayList<EMP>();
Connection conn=null;
PreparedStatement pst=null;
ResultSet res=null;
try {
conn=Mai.getConnection();
pst=conn.prepareStatement(sql);
if(sql.contains("SELECT")) {//判断是不是查询语句是查询语句就走下一步
res =pst.executeQuery();
while(res.next()) {
String id = res.getString("id");
String name = res.getString("name");
EMP emp =new EMP();
emp.setId(id);
emp.setName(name);
arr.add(emp);
}
}else {//不是查询语句进行常规操作
pst.executeUpdate();
}
return arr;
} catch (Exception e) {
e.printStackTrace();
}
return arr;
}
}
调用方法需把sql传递给crud类中的方法
import java.util.ArrayList;
import java.util.Scanner;
public class crudDemo{
public static void main(String[] args) {
crud s1 = new crud();
Scanner scan = new Scanner(System.in);
// String sql="SELECT * FROM `lx`.`xl`";
// ArrayList<EMP>arr = s1.crud(sql);
// for(int i=0;i<arr.size();i++) {
// System.out.println(arr.get(i).getId()+" "+arr.get(i).getName());
// }
//增
// String sql = "INSERT INTO `lx`.`xl`VALUES ("+scan.next()+", '3')";
// s1.crud(sql);
//删
// String sql = "DELETE FROM `lx`.`xl` WHERE `id` = "+scan.next()+"";
// s1.crud(sql);
//改
// String a =scan.next();
// String b= scan.next();
// String sql = "UPDATE `lx`.`xl` SET `id` = "+a+" WHERE `id` = "+b+"";
// s1.crud(sql);
//
}
}