手撕-------BaseDao

//增删改
public int updata(String sql,Object[] arr){
Connection connection = Jdbautil.getConnestion;
PrepareStatement ps = connection.prepareStatement(sql);
int pc =ps.getParameterMetaData.getParameterCount();
Objeck[] arr = {,};
if(arr != null && arr.length == pc){
for(int i=1; i<=pc;i++){
ps.setObjeck(i,arr[i-1])
}
}
ps.executeUpdata()
}

//查
public List Query(String sql,Object[] arr ,Class cls){
Connection connection = Jdbautil.getConnestion;
PrepareStatement ps = connection.prepareStatement(sql);
int pc =ps.getParameterMetaData.getParameterCount();
Objeck[] arr = {,};
if(arr != null && arr.length == pc){
for(int i=1; i<=pc;i++){
ps.setObjeck(i,arr[i-1])
}
}
ResultSet rs = ps.executeQuery();
List list = new ArrayList<>();
ResultSetMetaDate md = rs.getMetaDate();
int cc = md.getColumnCount;
while(rs.next()){
T t = cls.getConstructor(null).newINstance(null);
for(int i = 1; i <= cc;i++){
Strint name = md.getColumnName(i);
Object value = re.getObject(cc);
BeanUtils.setProperty(t,name,value);
}
list.add(t);
}
return list.size() != 0; list : null;
}