public Customer create(Customer entity) throws Exception {
DBean db = new DBean();
PreparedStatement ps = null;
StringBuffer sb = new StringBuffer();
sb.append("Insert into Customer(");
sb.append("customerId,");
sb.append("customerName,");
sb.append("contectPerson,");
sb.append("district,");
sb.append("postcode,");
sb.append("address,");
sb.append("mobile,");
sb.append("phone,");
sb.append("fax,");
sb.append("url,");
sb.append("email,");
sb.append("accountBank,");
sb.append("accountNumber,");
sb.append("accountPerson,");
sb.append("mark,");
sb.append("customerPinYin,");
sb.append("abstractCustomer,");
sb.append("insertDate");
sb.append(") values(");
for (int i = 0; i < 18; i++) {
sb.append(i == 0 ? "?" : ",?");
}
sb.append(")");
try {
Connection con = db.getConnection();
ps = con.prepareStatement(sb.toString());
int pos = 1;
ps.setString(pos++, entity.getCustomerId());
ps.setString(pos++, entity.getCustomerName());
ps.setString(pos++, entity.getContectPerson());
ps.setString(pos++, entity.getDistrict());
ps.setString(pos++, entity.getPostcode());
ps.setString(pos++, entity.getAddress());
ps.setString(pos++, entity.getMobile());
ps.setString(pos++, entity.getPhone());
ps.setString(pos++, entity.getFax());
ps.setString(pos++, entity.getUrl());
ps.setString(pos++, entity.getEmail());
ps.setString(pos++, entity.getAccountBank());
ps.setString(pos++, entity.getAccountNumber());
ps.setString(pos++, entity.getAccountPerson());
ps.setString(pos++, entity.getMark());
ps.setString(pos++, entity.getCustomerPinYin());
ps.setString(pos++, entity.getAbstractCustomer());
ps.setDate(pos++, DateUtils.toSqlDate(entity.getInsertDate()));
ps.execute();
} catch (Exception e) {
e.printStackTrace();
} finally {
db.closeAll(null, ps, db);
}
return entity;
}
public void update(Customer entity) throws Exception {
DBean db = new DBean();
PreparedStatement ps = null;
StringBuffer sb = new StringBuffer();
sb.append("Update Customer set ");
sb.append("customerName=?,");
sb.append("contectPerson=?,");
sb.append("district=?,");
sb.append("postcode=?,");
sb.append("address=?,");
sb.append("mobile=?,");
sb.append("phone=?,");
sb.append("fax=?,");
sb.append("url=?,");
sb.append("email=?,");
sb.append("accountBank=?,");
sb.append("accountNumber=?,");
sb.append("accountPerson=?,");
sb.append("mark=?,");
sb.append("customerPinYin=?,");
sb.append("abstractCustomer=?,");
sb.append("insertDate=?");
sb.append(" where customerId = ?");
try {
Connection con = db.getConnection();
ps = con.prepareStatement(sb.toString());
int pos = 1;
ps.setString(pos++, entity.getCustomerName());
ps.setString(pos++, entity.getContectPerson());
ps.setString(pos++, entity.getDistrict());
ps.setString(pos++, entity.getPostcode());
ps.setString(pos++, entity.getAddress());
ps.setString(pos++, entity.getMobile());
ps.setString(pos++, entity.getPhone());
ps.setString(pos++, entity.getFax());
ps.setString(pos++, entity.getUrl());
ps.setString(pos++, entity.getEmail());
ps.setString(pos++, entity.getAccountBank());
ps.setString(pos++, entity.getAccountNumber());
ps.setString(pos++, entity.getAccountPerson());
ps.setString(pos++, entity.getMark());
ps.setString(pos++, entity.getCustomerPinYin());
ps.setString(pos++, entity.getAbstractCustomer());
ps.setDate(pos++, DateUtils.toSqlDate(entity.getInsertDate()));
ps.setString(pos++, entity.getCustomerId());
ps.execute();
} catch (Exception e) {
e.printStackTrace();
} finally {
db.closeAll(null, ps, db);
}
}
