Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public int executePreparedUpdate(String query, ArrayList<String> parameters) throws SQLException{
- PreparedStatement stmt = null;
- int result = -1;
- connectToServer();
- try{
- stmt = con.prepareStatement(query);
- System.out.println("1");
- if (parameters != null){
- for(int i = 0; i < parameters.size(); i++){
- if (parameters.get(i) == null)
- stmt.setString(i+1,"null");
- else
- stmt.setString(i+1, parameters.get(i));
- System.out.println(parameters.get(i));
- }
- }
- System.out.println("2");
- result = stmt.executeUpdate();
- System.out.println("3");
- return result;
- }catch(SQLException e){
- System.out.println("executePreparedQuery crashade!");
- }
- finally{
- closeConnection();
- try{
- if (stmt != null)
- stmt.close();
- }catch(SQLException e){}
- }
- return -1;
- }
- String query;
- ArrayList<String> parameters = new ArrayList<String>();
- if(name.getText().length() != 0 && race.getText().length() != 0 && sex.getText().length() != 0)
- try{
- query = "INSERT INTO T_ANIMAL (owner,species_name,name,race,sex) VALUES (?,?,?,?,?)";
- parameters.add(this.c.getEmail());
- parameters.add(this.animalRaces.getSelectedItem().toString());
- parameters.add(this.nameText.getText());
- parameters.add(this.raceText.getText());
- parameters.add(this.animalSexCombo.getSelectedItem().toString());
- DatabaseUtility.getInstance().executePreparedUpdate(query, parameters);
- if(journalText.getText().length() != 0){
- try{
- DatabaseUtility.getInstance().executeUpdate("INSERT INTO T_JOURNAL VALUES ('" + journalText.getText() + "')");
- }catch(SQLException sqle2){
- System.out.println("Error saving animal journal to database!");
- }
- }
- }catch(SQLException sqle){
- System.out.println("Error saving animal to database!");
- }
Add Comment
Please, Sign In to add comment