``java
/**
* 测试
*/
@Test
public void test() {
SmbmsUser smbmsUser = new SmbmsUser( new BigInteger("56"), "liji", "李吉" , "123123", 2 , new Date(),
"12345678999", "大海啊" , new BigInteger("2"), null, null, null, new java.sql.Date(System.currentTimeMillis()));
System.out.println(addSmbmsUser(smbmsUser));
//System.out.println(searchUserInformation());
}
/**
* 添加用户
* @param smbmsUser
* @return
*/
public int addSmbmsUser(SmbmsUser smbmsUser) {
String sql = "insert into smbms_user(id,userCode,userName,userPassword,gender,birthday,phone,***address"
+ ",userRole***,createdBy,creationDate,modifyBy,modifyDate) values(?,?,?,?,?,?,?,?,?,?,?,?,?)";
/*
JDBC出错:少了逗号" , ",报错:Column count doesn't match value count at row 1
String sql = "insert into smbms_user(id,userCode,userName,userPassword,gender,birthday,phone,***address"
+ "userRole***,createdBy,creationDate,modifyBy,modifyDate) values(?,?,?,?,?,?,?,?,?,?,?,?,?)";
*/
Object[] params = { smbmsUser.getUserID() , smbmsUser.getUserCode(), smbmsUser.getUserName(),
smbmsUser.getPassword(), smbmsUser.getGender(), smbmsUser.getBirthday(), smbmsUser.getPhone(),
smbmsUser.getAddress(), smbmsUser.getUserRole(), smbmsUser.getCreatedBy(), smbmsUser.getCreationDate(),
smbmsUser.getModifyBy(), smbmsUser.getModifyDate() };
return executeUpdate(sql, params);
}