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;
}
private static SignUpSubscriber getSignUpSubscriber(ResultSet resultSet) {
SignUpSubscriber signUpSubscriber = new SignUpSubscriber();
try {
signUpSubscriber.setiSubscriberID(resultSet.getInt("iSubscriberID"));
signUpSubscriber.setsName(resultSet.getString("sName"));
signUpSubscriber.setsEmail(resultSet.getString("sEmail"));
signUpSubscriber.setsPassword(resultSet.getString("sPassword"));
signUpSubscriber.setsAddress(resultSet.getString("sPhoneNumber"));
signUpSubscriber.setsPhoneNumber(resultSet.getString("sAddress"));
signUpSubscriber.setiDOB(resultSet.getDate("iDOB"));
signUpSubscriber.setiBalance(resultSet.getInt("iBalance"));
signUpSubscriber.setiRegistrationStatus(resultSet.getInt("iRegistrationStatus"));
return signUpSubscriber;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return signUpSubscriber;
}
