public boolean InsertUser(Users u) {
boolean b = true;
try {
Class.forName("com.mysql.jdbc.Driver");
ct = DriverManager.getConnection("jdbc:mysql://localhost:3306/walter", "root", "1234567890");
ps =
ct.prepareStatement(
"insert into users (username,password,email,address,city) values(?,?,?,?,?);");
ps.setObject(1, u.getUsername());
ps.setObject(2, u.getPassword());
ps.setObject(3, u.getEmail());
ps.setObject(4, u.getAddress());
ps.setObject(5, u.getCity());
ps.executeUpdate();
} catch (Exception e) {
b = false;
e.getStackTrace();
} finally {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
rs = null;
}
if (ps != null) {
try {
ps.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
ps = null;
}
if (ct != null) {
try {
ct.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
ct = null;
}
}
return b;
}
