public int saveImageData(ImageDTO dto) throws Exception { Connection con = null; int ret; try { con = new MyConnection().getConnection(); String query = "insert into tbl_tracker_image(username,c_date,c_time,fpath) values (?,?,?,?)"; PreparedStatement ps = con.prepareStatement(query); ps.setString(1, dto.getUsername()); ps.setString(2, dto.getC_date()); ps.setString(3, dto.getC_time()); ps.setString(4, dto.getFpath()); ret = ps.executeUpdate(); ps.close(); } catch (Exception e) { e.printStackTrace(); ret = 0; } finally { if (con != null) { con.close(); } } return ret; }