public boolean insertCompanyDetails(CompanyDetails com) {
boolean check = true;
PreparedStatement ps;
if (dbc.connect()) {
try {
String sqlQuery = "INSERT INTO " + COMPANY_INFO + " VALUES(?,?,?,?,?,?,?,?,?,?,?,?)";
ps = dbc.getConnection().prepareStatement(sqlQuery);
ps.setNString(1, com.getTenCtyVN());
ps.setString(2, com.getTenCtyEN());
ps.setString(3, com.getTenVietTat());
ps.setNString(4, com.getTenGiamDoc());
ps.setString(5, com.getSoDienThoai());
ps.setString(6, com.getSoFax());
ps.setString(7, com.getSoTaiKhoan());
ps.setNString(8, com.getDiaChiVN());
ps.setNString(9, com.getDiaChiEN());
ps.setString(10, com.getMaSoThue());
if (com.getNgayDangKy() == null) {
ps.setNull(11, java.sql.Types.DATE);
} else {
ps.setDate(11, com.getNgayDangKy());
}
ps.setBytes(12, com.getLogo());
if (ps.executeUpdate() < 1) {
check = false;
}
} catch (SQLException ex) {
Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex);
}
}
return check;
}
public CompanyDetails getCompanyDetails() {
CompanyDetails com = new CompanyDetails();
PreparedStatement ps;
ResultSet rs;
if (dbc.connect()) {
try {
String sqlQuery = "select * from " + COMPANY_INFO;
ps = dbc.getConnection().prepareStatement(sqlQuery);
rs = ps.executeQuery();
while (rs.next()) {
com.setTenCtyVN(rs.getNString(1));
System.out.println(rs.getNString(1));
com.setTenCtyEN(rs.getString(2));
com.setTenVietTat(rs.getString(3));
com.setTenGiamDoc(rs.getNString(4));
com.setSoDienThoai(rs.getString(5));
com.setSoFax(rs.getString(6));
com.setSoTaiKhoan(rs.getString(7));
com.setDiaChiVN(rs.getNString(8));
com.setDiaChiEN(rs.getNString(9));
com.setMaSoThue(rs.getString(10));
com.setNgayDangKy(rs.getDate(11));
com.setLogo(rs.getBytes(12));
}
} catch (SQLException ex) {
Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex);
}
}
return com;
}
