暴劫倾情下载,郑羽婷,天下枭雄5200
代码本身很简单。拼接sql的时候?不好数,简单的用来赋值。
/**
* todo 循环赋值,缺少的类型可随时添加
* @author lucius
* @param pt
* @param list
* @throws sqlexception
*/
public static void setparam(preparedstatement pt, list list) throws sqlexception{
for(int i = 0;i<list.size();i++){
if (list.get(i) instanceof string) pt.setstring(i+1, list.get(i).tostring());
else if(list.get(i) instanceof integer) pt.setint(i+1, integer.parseint(list.get(i).tostring()));
else if(list.get(i) instanceof short)pt.setshort(i+1, short.parseshort(list.get(i).tostring()));
else pt.setobject(i+1, list.get(i));
}
}
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!!
点击进行留言回复
网友评论