Advertisement
Guest User

Untitled

a guest
Jul 21st, 2017
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.73 KB | None | 0 0
  1.     public void Update(String q, Object[] args) {
  2.         try {
  3.             PreparedStatement stmt;
  4.  
  5.             //Get a Statement object
  6.             stmt = con.prepareStatement(q);
  7.  
  8.             for(int i = 0; i < args.length; i++) {
  9.                 Object o = args[i];
  10.                 if (o.getClass().getName() == "java.lang.String") stmt.setString(i+1, (java.lang.String)args[i]);
  11.                 if (o.getClass().getName() == "java.lang.Integer") stmt.setInt(i+1, (java.lang.Integer)args[i]);
  12.                 if (o.getClass().getName() == "java.math.BigDecimal") stmt.setBigDecimal(i+1, (java.math.BigDecimal)args[i]);
  13.             }
  14.             stmt.execute();
  15.            
  16.         } catch ( Exception e ) {
  17.             System.out.println("query except: "+e.toString()+" "+e.getMessage()); // e.printStackTrace();
  18.             e.printStackTrace();
  19.         }//end catch
  20.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement