jdbc操作步骤

1.导入驱动jar包 mysql-connector-java-5.1.49-bin.jar
2.注册驱动
3.获取数据库连接对象 connection
4.定义sql
5.获取执行sql语句的对象 statement
6.执行sql,接受返回结果
7.处理结果
8.释放资源

例:
/1.导入驱动jar包
//2.注册驱动
Class.forName(“com.mysql.jdbc.Driver”);

	//3.获取数据库的连接对象
	Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/db1","root", "root");
	
	//4.定义sql语句
	String  sql = "update student set   age =20 where name ='zhangsan'";
	
	//5.获取执行sql的对象 statement
	Statement sta = connection.createStatement();

	//6.执行sql
	int count = sta.executeUpdate(sql);
	//7.处理结果
	System.out.println(count);
	
	//8.释放资源
	sta.close();
	connection.close();