public static void main(String[] args) throws Exception {
IAccountDAO dao = new AccountDAOImpl();
// List<Account> accs =
// dao.findByCondition(null, null, null, null,2,5);
// for(Account acc : accs){
// System.out.println(acc.getId()+","+acc.getIdcardNo()+","+acc.getRealName());
// }
// int totalPage = dao.findTotalPage(null, null, null, null, 5);
// System.out.println(totalPage);
// dao.startAccount(1018);
// Account account = dao.findById(1018);
// System.out.println(account.getStatus());
// Account acc = dao.findByIdcardNo("330682196903190613");
// System.out.println(acc.getId());
Account account = new Account();
account.setEmail("*****@*****.**");
account.setLoginName("dkfj");
account.setIdcardNo("130281199207271123");
account.setLoginPassword("dfad");
account.setRealName("小米");
account.setTelephone("41551");
dao.addAccount(account);
}
private Account createAccount(ResultSet rs) throws Exception {
Account a = new Account();
a.setId(rs.getInt("id"));
a.setRecommenderId(rs.getInt("recommender_id"));
a.setLoginName(rs.getString("login_name"));
a.setLoginPassword(rs.getString("login_passwd"));
a.setStatus(rs.getString("status"));
a.setCreateDate(rs.getDate("create_date"));
a.setPauseDate(rs.getDate("pause_date"));
a.setCloseDate(rs.getDate("close_date"));
a.setRealName(rs.getString("real_name"));
a.setIdcardNo(rs.getString("idcard_no"));
a.setBirthdate(rs.getDate("birthdate"));
a.setGender(rs.getString("gender"));
a.setOccupation(rs.getString("occupation"));
a.setTelephone(rs.getString("telephone"));
a.setEmail(rs.getString("email"));
a.setMailaddress(rs.getString("mailaddress"));
a.setZipcode(rs.getString("zipcode"));
a.setQq(rs.getString("qq"));
a.setLastLoginTime(rs.getDate("last_login_time"));
a.setLastLoginIp(rs.getString("last_login_ip"));
return a;
}
public void addAccount(Account account) throws DAOException {
if (account == null) {
return;
}
String sql =
"insert into account values(seq_account.nextval,?,?,?,'1',sysdate,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
Connection conn = DBUtil.getConnection();
try {
conn.setAutoCommit(false);
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setObject(1, account.getRecommenderId());
pstmt.setObject(2, account.getLoginName());
pstmt.setObject(3, account.getLoginPassword());
pstmt.setObject(4, account.getPauseDate());
pstmt.setObject(5, account.getCloseDate());
pstmt.setObject(6, account.getRealName());
pstmt.setObject(7, account.getIdcardNo());
pstmt.setObject(8, account.getBirthdate());
pstmt.setObject(9, account.getGender());
pstmt.setObject(10, account.getOccupation());
pstmt.setObject(11, account.getTelephone());
pstmt.setObject(12, account.getEmail());
pstmt.setObject(13, account.getMailaddress());
pstmt.setObject(14, account.getZipcode());
pstmt.setObject(15, account.getQq());
pstmt.setObject(16, account.getLastLoginTime());
pstmt.setObject(17, account.getLastLoginIp());
pstmt.executeUpdate();
conn.commit();
} catch (SQLException e) {
try {
conn.rollback();
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
e.printStackTrace();
throw new DAOException("账务账号插入失败！", e);
}
}