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;
}
