Advertisement
Guest User

Untitled

a guest
Jun 24th, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.72 KB | None | 0 0
  1.     public void insertProject(String projectName, String desc, String context) throws SQLException{
  2.          int i;
  3.         Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE );
  4.         ResultSet uprs = stmt.executeQuery("SELECT * FROM projects");
  5.         uprs.moveToInsertRow();
  6.         if(projects.isEmpty()){
  7.             i = 0;
  8.         }
  9.         else{
  10.           i = projects.get(projects.size()-1).getProjectID();
  11.         }
  12.        
  13.         i++;
  14.         uprs.updateInt("projectID", i);
  15.         uprs.updateString("projectName", projectName);
  16.         uprs.updateString("description", desc);
  17.         uprs.updateString("context", context);
  18.         uprs.insertRow();
  19.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement