Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void insertProject(String projectName, String desc, String context) throws SQLException{
- int i;
- Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE );
- ResultSet uprs = stmt.executeQuery("SELECT * FROM projects");
- uprs.moveToInsertRow();
- if(projects.isEmpty()){
- i = 0;
- }
- else{
- i = projects.get(projects.size()-1).getProjectID();
- }
- i++;
- uprs.updateInt("projectID", i);
- uprs.updateString("projectName", projectName);
- uprs.updateString("description", desc);
- uprs.updateString("context", context);
- uprs.insertRow();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement