public boolean addMarketingOfficer(MarketingOfficer marketingOfficer)
throws SQLException, ClassNotFoundException {
Connection connection = DataBaseConnection.getConnection();
Statement createStatement = connection.createStatement();
String sql =
"INSERT INTO MARKETINGOFFICER (marketingofficerid,name,nic,address,telno) "
+ "VALUES ('"
+ marketingOfficer.getMarketingOfficerId()
+ "','"
+ marketingOfficer.getName()
+ "','"
+ marketingOfficer.getNic()
+ "','"
+ marketingOfficer.getAddress()
+ "','"
+ marketingOfficer.getTelNo()
+ "')";
int res = createStatement.executeUpdate(sql);
if (res > 0) {
return true;
} else {
return false;
}
}
