1、创建数据库连接
public Connection getConnection(){
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver"); // 加载数据库驱动,注册到驱动管理器
String url = "jdbc:mysql://localhost:3306/simplelogin"; // 数据库连接字符串
String username = "root"; // 数据库用户名
String password = "root"; // 数据库密码
conn = DriverManager.getConnection(url,username,password);
} catch(ClassNotFoundException e) {
e.printStackTrace();
System.out.println("加载数据库驱动失败:ClassNotFoundException!");
} catch (SQLException e1) {
e1.printStackTrace();
System.out.println("数据库连接失败:SQLException!");
}
return conn;
}
2、更新数据库数据
public boolean updateFrom(){
Connection conn = JdbcUtils.getConnection();
PreparedStatement ps = null;
boolean flag = false;
String sql = "update user set password=?, email=?, birthday=?, nickname=? where username=?";
try {
ps = conn.prepareStatement(sql);
ps.setString(1, "111111");
ps.setString(2, "aaaaaa@qq.com");
ps.setString(3, "1111-11-11");
ps.setString(4, "aaaaaa");
ps.setString(5, "aaaaaa";
int i = ps.executeUpdate();
if (i != 0) {
flag = true;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return false;
}
}