JDBC更新MySQL数据库

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