public static int insert(SignUpSubscriber signUpSubscriber) { String url = "jdbc:mysql://localhost:3306/jspproject"; int ret = 0; ResultSet rs = null; try { String insert = "INSERT INTO tsignupsubscriber(sName,sEmail,sPassword,sPhoneNumber,sAddress,iDOB,iBalance,iRegistrationStatus)" + "VALUES (?, ?, ?, ?, ?, ?, ?,?)"; // System.out.println(session.get("RegisterSeller")); Class.forName("com.mysql.jdbc.Driver"); Connection con = DriverManager.getConnection(url, "root", "1234"); PreparedStatement ps = con.prepareStatement(insert); ps.setString(1, signUpSubscriber.getsName()); ps.setString(2, signUpSubscriber.getsEmail()); ps.setString(3, signUpSubscriber.getsPassword()); ps.setString(4, signUpSubscriber.getsPhoneNumber()); ps.setString(5, signUpSubscriber.getsAddress()); ps.setDate(6, signUpSubscriber.getiDOB()); ps.setInt(7, signUpSubscriber.getiBalance()); int iRegStatus = 1; ps.setInt(8, iRegStatus); ret = ps.executeUpdate(); con.close(); } catch (Exception ex) { ex.printStackTrace(); } return ret; }