数据库方法的代码:publicstaticintexectuIUD(Stringsql,Object[]params){intcount=0;Connectionconn=Basedao.getconn();PreparedStatementps=null;try{:ps=conn.prepareStatement(sql...
数据库方法的代码:public static int exectuIUD(String sql,Object[] params){
int count=0;
Connection conn=Basedao.getconn();
PreparedStatement ps=null;
try {
:ps=conn.prepareStatement(sql);
//System.out.printlnln(sql);
if(params!=null){
for (int i = 0; i < params.length; i++) {
ps.setObject(i+1, params[i]);
}
}
count=ps.executeUpdate();
使用数据库类的代码:
public static int update(EASYBUY_USER u){
String sql = "update EASYBUY_USER set EU_USER_NAME=?," +
"EU_PASSWORD=?," +
"EU_SEX=?," +
"EU_BIRTHDAY=?," +
"EU_IDENTITY_CODE=?," +
"EU_EMAIL=?," +
"EU_MOBILE=?," +
"EU_ADDRESS=?," +
"EU_STATUS=? " +
"where EU_USER_ID=?";
Object[] params = {u.getEU_USER_NAME(),
u.getEU_PASSWORD(),
u.getEU_SEX(),
u.getEU_BIRTHDAY(),
u.getEU_IDENTITY_CODE(),
u.getEU_EMAIL(),
u.getEU_MOBILE(),
u.getEU_ADDRESS(),
u.getEU_STATUS(),
u.getEU_USER_ID()};
return Basedao.exectuIUD(sql, params);输入中文到EU_ADDRESS,在数据库中出现乱码。请大神指教。
展开