JDBC连接数据库

**

java学习JDBC

** 1.导入jar包 mysql-connector-java-5.1.37-bin.jar
2.注册驱动
Class.forName(“com.mysql.jdbc.Driver”);//加载这个类
3.获取数据库连接对象 Connection
Connection conn = DriverManager.getConnection(“jdbc:mysql:///db4”,“root”, “root”);
4.定义sql
String sql = "update student set age = 35 where id = 1 ";
5.获取执行sql语句的对象 Statement
Statement stat = conn.createStatement();
6.执行sql，接受返回结果
int count = stat.executeUpdate(sql);
7.处理结果
System.out.println(count);
8.释放资源
stat.close();
conn.close();**

**