public MarketingOfficer searchMarketingOfficer(String marketingOfficer)
throws SQLException, ClassNotFoundException {
Connection connection = DataBaseConnection.getConnection();
Statement createStatement = connection.createStatement();
String sql =
"select * from marketingofficer where marketingofficerid='" + marketingOfficer + "'";
System.out.println(sql);
ResultSet executeQuery = createStatement.executeQuery(sql);
MarketingOfficer mo = new MarketingOfficer();
while (executeQuery.next()) {
mo.setName(executeQuery.getString("name"));
mo.setNic(executeQuery.getString("nic"));
mo.setAddress(executeQuery.getString("address"));
mo.setTelNo(executeQuery.getString("telNo"));
}
return mo;
}
