java - insert "Finally" to complete the code -

i hav written program in java using both , set method....but not give me desired output tells insert block code given below..in console of eclipse shows connected no values of table displayed

      package com.glomindz.mercuri.dao;  import java.sql.connection; import java.sql.preparedstatement; import java.sql.resultset; import java.sql.sqlexception; import java.util.arraylist; import java.util.list;  import com.glomindz.mercuri.pojo.user; import com.glomindz.mercuri.util.mysingleton;    public class userservicesdao {  private connection connection;  public userservicesdao() {     // connection = new mysingleton().getconnection();     connection = mysingleton.getinstance().getconnection();  }  public list<user> get_all_data() {     list<user> userslist = new arraylist<user>();      string query = "select * spl_user_master";     try {          preparedstatement stmt = connection.preparestatement(query);          boolean execute = stmt.execute();         system.out.println(execute);         resultset resultset = stmt.getresultset();         system.out.println(resultset.getmetadata());         while (resultset.next()) {             user user = new user();             user.setid(resultset.getint("id"));             user.setname(resultset.getstring("name"));             user.setemail(resultset.getstring("email"));             user.setmobile(resultset.getstring("mobile"));             user.setpassword(resultset.getstring("password"));             user.setrole(resultset.getstring("role"));             user.setstatus(resultset.getstring("status"));             user.setlast_udpate(resultset.getstring("last_update"));             userslist.add(user);         }     }     }       public list<user> set_all_data() {         list<user> userslist = new arraylist<user>();          try {              preparedstatement stmt = connection.preparestatement("insert spl_user_master(name,email,mobile,password,role,status,last_update)values(?,?,?,?,?,?,?)");              stmt.setstring(1, "charlie sheen");              stmt.setstring(2, "help@glomindz.com");              stmt.setstring(3, "9554087107");              stmt.setstring(4, "cbf91a71c21d5ec348b0c749b2f0055k");              stmt.setstring(5, "user");              stmt.setstring(6, "3");              stmt.setstring(7, "2013-07-02 22:05:16");                boolean execute = stmt.execute();             system.out.println(execute);             stmt.getresultset();          }           catch (sqlexception e) {             // todo auto-generated catch block             e.printstacktrace();         }      return userslist;         }          public static void main(string[] args) {     userservicesdao userdao = new userservicesdao();     list<user> data = userdao.get_all_data();     list<user> data1 = userdao.set_all_data();     system.out.println(data);     system.out.println(data1);     system.exit(0);                 }                    } 

whats wrong code plz specify

in java, try block must followed either catch or finally block. in code have below try block, not followed catch/finally block(s).

  try {          preparedstatement stmt = connection.preparestatement(query);          boolean execute = stmt.execute();         system.out.println(execute);         resultset resultset = stmt.getresultset();         system.out.println(resultset.getmetadata());         while (resultset.next()) {             user user = new user();             user.setid(resultset.getint("id"));             user.setname(resultset.getstring("name"));             user.setemail(resultset.getstring("email"));             user.setmobile(resultset.getstring("mobile"));             user.setpassword(resultset.getstring("password"));             user.setrole(resultset.getstring("role"));             user.setstatus(resultset.getstring("status"));             user.setlast_udpate(resultset.getstring("last_update"));             userslist.add(user);         }     } // missing catch/finally statements 

you can either add catch block handle exception happening in above try block code or put block. general construct try block is

try {     code } catch , blocks . . . 

learn more java exception handling here: http://docs.oracle.com/javase/tutorial/essential/exceptions/handling.html