I have 2 methods working in my class file that I am trying to convert into 1 method:
CODE
.....
public Preparestatement prep;
public int inserterOne(TheBean mybean)
{
int status = 0;
try {
prep.connection.preparestatement("insert into person (city, state) values (?,?)");
prep.setString(1,mybean.getCity());
prep.setString(2,mybean.getState());
prep.executeUpdate();
}
catch(Exception e) {
e.printStacktrace();
}
return status;
}
public int inserterTwo(TheBean mybean)
{
int status = 0;
try {
prep.connection.preparestatement("insert into person (city, state) values (?,?)");
prep.setString(1,mybean.getMainCity());
prep.setString(2,mybean.getMainState());
prep.executeUpdate();
}
catch(Exception e) {
e.printStacktrace();
}
return status;
}
public int hitter(TheBean mybean)
{
.....
inserterOne(mybean);
inserterTwo(mybean);
...
Here is my attempt and not sure how to make this work?
CODE
public int inserterCombined(TheBean mybean)
{
int status = 0;
try {
prep.connection.preparestatement("insert into person (city, state) values (?,?)");
prep.setString(1,mybean.getCity());
prep.setString(2,mybean.getState());
prep.executeUpdate();
prep.setString(1,mybean.getMainCity());
prep.setString(2,mybean.getMainState());
prep.executeUpdate();
}
catch(Exception e) {
e.printStacktrace();
}
return status;
}
....
public int hitter(TheBean mybean)
{
.....
inserterCombined(?? here); //how would I know which part of the method to call here?
Please advise how I can get this to work. Thanks
| 