java入门学习（0）—— Java连接mysql；处理mysql数据库、数据表的增删改。

1、下载mysql的jar包
https://dev.mysql.com/get/archives/mysql-connector-java-8.0/mysql-connector-java-8.0.28.zip
解压后，有一个mysql-connector-java-8.0.28.jar文件
2、在idea中倒入下载好的jar包
在工程目录下新建一个lib路径；
把jar包复制粘贴进来；
右键把目录添加为library；

3、数据库的各种操作
// 连接数据库

public Connection getConnection() {
    try {
        Class.forName("com.mysql.cj.jdbc.Driver");

    } catch (ClassNotFoundException e) {
        System.out.print("加载驱动失败!");
        throw new RuntimeException(e);
    }
    user = "root";
    paswd = "root";
    try {
        connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncodeing=gbk", user, paswd);
        System.out.println("数据库链接成功");
    } catch (SQLException e) {
        throw new RuntimeException(e);
    }
    return connection;

}

//创建数据表

public boolean createtable() throws SQLException {
    Connection connection1 = getConnection();
    Statement statement = connection1.createStatement();
    try{
        statement.executeUpdate(
                "create table if not exists `user` (" +
                        "`index` int, " +
                        "`phone` varchar(80) not null ," +
                        "PRIMARY KEY ( `index` ))" +
                        "ENGINE=InnoDB DEFAULT CHARSET=utf8;");
        return true;
    } catch (SQLException e) {
        throw new RuntimeException(e);
    }
}

//插入数据

public boolean insertInto(int index, String uid, String phone) throws SQLException {
    Connection connection1 = getConnection();
    Statement statement = connection1.createStatement();
    try {
        statement.executeUpdate("insert into using_user values (" + index +"," + phone +") on duplicate key update `index`=`index`;");
        return true;
    } catch (SQLException e) {
        throw new RuntimeException(e);
    }
}

//整体代码

import java.sql.*;

public class DbController {
    Connection connection;
    public static String user;
    public static String password;

// 连接数据库
    public Connection getConnection() {
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");

        } catch (ClassNotFoundException e) {
            System.out.print("加载驱动失败!");
            throw new RuntimeException(e);
        }
        user = "root";
        paswd = "root";
        try {
            connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncodeing=gbk", user, paswd);
            System.out.println("数据库链接成功");
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
        return connection;

    }

//创建数据表
	public boolean createtable() throws SQLException {
        Connection connection1 = getConnection();
        Statement statement = connection1.createStatement();
        try{
            statement.executeUpdate(
                    "create table if not exists `user` (" +
                            "`index` int, " +
                            "`phone` varchar(80) not null ," +
                            "PRIMARY KEY ( `index` ))" +
                            "ENGINE=InnoDB DEFAULT CHARSET=utf8;");
            return true;
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }

//插入数据
	public boolean insertInto(int index, String uid, String phone) throws SQLException {
        Connection connection1 = getConnection();
        Statement statement = connection1.createStatement();
        try {
            statement.executeUpdate("insert into using_user values (" + index +"," + phone +") on duplicate key update `index`=`index`;");
            return true;
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }
}