package Util; import java.beans.PropertyDescriptor; import java.util.ArrayList; import java.util.List; import java.util.regex.Matcher; import java.util.regex.Pattern; import org.apache.commons.beanutils.BeanUtils; import org.apache.commons.beanutils.PropertyUtils; public class SqlParameter { private String Matcher_Value = "@\\w+"; private String SQL; public String getSQL() { return SQL; } public void setSQL(String sQL) { SQL = sQL; } public List GetPreparedStatement(String SQL_,T t) { List MyResult = new ArrayList(); List list = JavaModel(t); List list_ment = GetSqlParment(SQL_); for(int i =0;i=0) { try { String Value = BeanUtils.getProperty(t, list_ment.get(i).getValue()); //ment.setObject(list_ment.get(i).index, Value); MyResult.add(Value); } catch (Exception e) {e.printStackTrace();} } } return MyResult; } private List GetSqlParment(String SQL_) { List list = new ArrayList(); Matcher mat = Pattern.compile(Matcher_Value).matcher(SQL_); int index = 0; while(mat.find()) { dbSqlParameter model = new dbSqlParameter(); String value = mat.group(); model.setIndex(index); model.setValue(value.replace("@","")); list.add(model); index++; } SQL = mat.replaceAll("?"); return list; } private List JavaModel(T t) { List list = new ArrayList(); PropertyDescriptor[] pd = PropertyUtils.getPropertyDescriptors(t); for(int i = 0;i
sqlparameter java_java模拟.net中的sqlparameter
最新推荐文章于 2022-03-21 11:09:01 发布