| 发表于:2007-05-22 12:27:166楼 得分:0 |
以下是op_user.class部份源码: //添加新用户 public boolean add(httpservletrequest req) throws exception { if (getrequest(req)) { database db = new database(); //db.connect(); //stmt = db.conn.createstatement (); //sqlstr = "select * from shop_user where username = ' " + // user.getusername() + " ' "; sqlstr = "insert into shop_user (username,password,names,sex, "+ "address,phone,post,email,regtime,regipaddress) values ( ' "; sqlstr = sqlstr + dataformat.tosql(user.getusername()) + " ', ' "; sqlstr = sqlstr + dataformat.tosql(user.getpassword()) + " ', ' "; sqlstr = sqlstr + dataformat.tosql(user.getnames()) + " ', ' "; sqlstr = sqlstr + dataformat.tosql(user.getsex()) + " ', ' "; sqlstr = sqlstr + dataformat.tosql(user.getaddress()) + " ', ' "; sqlstr = sqlstr + dataformat.tosql(user.getphone()) + " ', ' "; sqlstr = sqlstr + dataformat.tosql(user.getpost()) + " ', ' "; sqlstr = sqlstr + dataformat.tosql(user.getemail()) + " ',getdate(), ' "; sqlstr = sqlstr + user.getregipaddress() + " ') "; try { db.stmt.EXECuteupdate(sqlstr); sqlstr = "select max(id) from shop_user where username = ' " + dataformat.tosql(user.getusername())+ " ' "; rs = db.stmt.EXECutequery(sqlstr); while (rs.next()) { userid = rs.getlong(1); } rs.close(); db.finalize(); return true; } catch (exception sqle) { system.out.print(sqle.getmessage()); return false; } } else { return false; } } | | |
|