Java操作MySQL数据库基础（一）

navicat操作流程

使用Java对Mysql数据库的实现增删改查 

 使用的软件是IDEA（），mysql-connector-java-8.0.16（8.0版）驱动下载在博文下方

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class JdbcUtils {
    //静态代码块：随着类的加载只执行一次
    static {
        //使用第三方jar报jdbc操作数据库
        try {
            new com.mysql.jdbc.Driver();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    public void add(){
        Connection conn=null;
        Statement state=null;
        //创建连接 url form http://127.0.0.1:3306/name?username=zhi&password=pwd
        //         url      jdbc:mysql://127.0.0.1:3306/test02
        try {
             conn= DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test02?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&useSSL=false","root","wPn@123");
            //新建查询窗口
             state=conn.createStatement();
            //写sql语句
         String sql ="insert into cat(name,age) values('中文',5)";
            //执行
            int result = state.executeUpdate(sql);
            System.out.println(result);
            //关流
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            try {
                state.close();
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
    public void update(){
        Connection conn=null;
        Statement state=null;
        try {
            conn= DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test02?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&useSSL=false","root","wPn@123");
            //新建查询窗口
            state=conn.createStatement();
            //写sql语句
            String sql="update cat set name='测试' where id=3";
            //执行
            int result = state.executeUpdate(sql);
            System.out.println(result);
            //关流
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            try {
                state.close();
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

    public void delete(){
        Connection conn=null;
        Statement state=null;
        try {
            conn= DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test02?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&useSSL=false","root","wPn@123");
            //新建查询窗口
            state=conn.createStatement();
            //写sql语句
            String sql="delete from cat where id=3";
            //执行
            int result = state.executeUpdate(sql);
            System.out.println(result);
            //关流
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            try {
                state.close();
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
    //查询
    public void select() {
        Connection conn = null;
        Statement state = null;
        ResultSet rs = null;
        try {
            conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test02?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&useSSL=false", "root", "wPn@123");
            //创建查询窗口
            state = conn.createStatement();
            String sql = "select id,name,age from cat";
            rs = state.executeQuery(sql);
            //循环打印结果
            while (rs.next()){
               int id= rs.getInt("id");
                String name = rs.getString("name");
                int age = rs.getInt("age");
                System.out.println("cat的id："+id+"   cat的name："+name+"   cat的age："+age+"\n");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            try {
                rs.close();
                //关闭查询窗口
                state.close();
                //关闭连接
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

查询出来的结果：

mysql-connector-java-8.0.16驱动下载

链接：https://pan.baidu.com/s/16Xmxfn6HevC22hhrtYyQxQ 
提取码：9c5m

mysql-connector-java-5.1.38驱动下载

链接：https://pan.baidu.com/s/18qsTlXAVvJWQL3fqAeEAJw 
提取码：ulzm