JDBC快速入门

1. 将数据库对应的jar包导入到项目中
2. 注册驱动
3. 获取数据库连接对象
4. 定义sql
5. 获取sql的执行对象
6. 执行sql
7. 处理sql执行结果
8. 释放资源

代码如下(jdbc操作mysql)

package cn.xatu.jdbc.demo1;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;


public class JdbcDemo3 {
    public static void main(String[] args) {
        Connection connection = null;
        Statement stmt = null;
        try {
            //1.注册驱动
            Class.forName("com.mysql.jdbc.Driver");
            //2.获取数据库连接对象
            connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/db1", "root", "root");
            //3.定义sql
            //String sql1 = "update account set name='张三' where id=1";
            String sql2 = "update account set name='李四' where id=2";
            //4.获取sql的执行对象
            stmt = connection.createStatement();
            //5.执行sql
            int count = stmt.executeUpdate(sql2);
            //6.处理执行结果
            if (count>0){
                System.out.println("修改成功");
            }else {
                System.out.println("修改失败");
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            //释放资源
            //避免空指针，释放资源前需要判空
            if (stmt!=null){
                try {
                    stmt.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            if (connection!=null){
                try {
                    connection.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }
    }
}

执行结果