public Users findUser(String email) {
Users user = new Users();
try {
Class.forName("com.mysql.jdbc.Driver");
ct = DriverManager.getConnection("jdbc:mysql://localhost:3306/walter", "root", "1234567890");
ps = ct.prepareStatement("select * from users where email=?;");
ps.setObject(1, email);
rs = ps.executeQuery();
rs.next();
user.setId(rs.getInt(1));
user.setEmail(rs.getString(2));
user.setUsername(rs.getString(3));
user.setPassword(rs.getString(4));
user.setCity(rs.getString(5));
user.setAddress(rs.getString(6));
} catch (Exception e) {
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 user;
}
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;
}
public boolean CheckUser(Users u) {
boolean b = false;
try {
Class.forName("com.mysql.jdbc.Driver");
ct = DriverManager.getConnection("jdbc:mysql://localhost:3306/walter", "root", "1234567890");
ps = ct.prepareStatement("select * from users where email=? and password=?;");
ps.setObject(1, u.getEmail());
ps.setObject(2, u.getPassword());
rs = ps.executeQuery();
if (rs.next()) {
b = true;
}
} catch (Exception e) {
e.printStackTrace();
} 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;
}
