int rs = st.executeUpdate("insert into \"Sys_User\"(\"UserID\","
+ UserName + "," + UserPwd + "," + DutyID + "," + RoleID + ","
+ Code + "," + LoginNum + "," + LastDate + "," + LastIP + ","
+ Locked + "," + MobilNum + "," + Tel + "," + Birthday + ","
+ RealName + ") values('" + u.getUserID() + "','"
+ u.getUserName() + "','" + u.getUserPwd() + "','"
+ u.getDutyID() + "','" + u.getRoleID() + "','" + u.getCode()
+ "'," + u.getLoginNum() + ",to_date('" + new Date()
+ "','yyyy-mm-dd-hh:mm:ss'),,'" + u.getLastIP() + "',"
+ u.getLocked() + ",'" + u.getMobilNum() + "','" + u.getTel()
+ "',to_date('" + new Date() + "','yyyy-mm-dd-hh:mm:ss'),'"
+ u.getRealName() + "')");
速度啦解决了都给分
+ UserName + "," + UserPwd + "," + DutyID + "," + RoleID + ","
+ Code + "," + LoginNum + "," + LastDate + "," + LastIP + ","
+ Locked + "," + MobilNum + "," + Tel + "," + Birthday + ","
+ RealName + ") values('" + u.getUserID() + "','"
+ u.getUserName() + "','" + u.getUserPwd() + "','"
+ u.getDutyID() + "','" + u.getRoleID() + "','" + u.getCode()
+ "'," + u.getLoginNum() + ",to_date('" + new Date()
+ "','yyyy-mm-dd-hh:mm:ss'),,'" + u.getLastIP() + "',"
+ u.getLocked() + ",'" + u.getMobilNum() + "','" + u.getTel()
+ "',to_date('" + new Date() + "','yyyy-mm-dd-hh:mm:ss'),'"
+ u.getRealName() + "')");
速度啦解决了都给分
String Locked="\"Locked\"",MobilNum="\"MobilNum\"",Birthday="\"Birthday\"",RealName="\"RealName\"";
String DutyID="\"DutyID\"",Tel="\"Tel\"";
String table = "\"Sys_User\"";
'yyyy-mm-dd-hh:mm:ss'
这中间的‘-’是不是改成空格
这里多了个逗号,多谢2楼 三楼