MySQL数据库之三、IDEA中如何创建库，表，数据以及查询

import org.junit.BeforeClass;
import org.junit.Test;

import javax.xml.transform.Result;
import java.sql.*;

/*
ALTER TABLE logtest CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

ALTER TABLE logtest DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

ALTER TABLE logtest CHANGE title title VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci;
*/
public class Demo2 {

@BeforeClass
public static void beforeClass(){
    //注册驱动
    try {
        Class.forName("com.mysql.jdbc.Driver");
    }catch (ClassNotFoundException e){
        e.printStackTrace();
    }
}

//创建数据库，表
@Test
public void testCreatDBAndTable() throws SQLException {
    //2.获取连接
    String url="jdbc:mysql://localhost:3306/test01?useSSL=false&characterEncoding=utf8";
    try {
        Connection conn = DriverManager.getConnection(url,"root","meng452645636");
        //3、创建命令
        Statement stat = conn.createStatement();
        //执行命令
        //int result = stat.executeUpdate("create database test02");
        int result = stat.executeUpdate("create table student(id int primary key,name varchar(20))");
        System.out.println("执行成功");
    }catch (SQLException e){
        e.printStackTrace();
        System.out.println("执行失败");
    }
}

//添加数据
@Test
public void testInsert(){
    //2、获取连接
    String url = "jdbc:mysql://localhost:3306/test01?useSSL=false&characterEncoding=utf8";
    try {
        Connection conn = DriverManager.getConnection(url,"root","meng452645636");
        Statement stat = conn.createStatement();
        //int result = stat.executeUpdate("insert into student(id,name)values (12,'爸爸')");
        int result = stat.executeUpdate("insert into student(id,name)value (11,'三姐')");
        System.out.println(result);
        stat.close();
        conn.close();
        System.out.println("执行成功");
    }catch (SQLException e){
        e.printStackTrace();
        System.out.println("执行失败");
    }
}

//查询数据
@Test
public void testQuery(){
    String url = "jdbc:mysql://localhost:3306/test01?useSSL=false&characterEncoding=utf8";
    try {
        Connection conn = DriverManager.getConnection(url,"root","meng452645636");
        Statement stat = conn.createStatement();
        ResultSet rs = stat.executeQuery("select name,id from student");
        while (rs.next()){
            int id = rs.getInt("id");
            String name = rs.getString("name");
            System.out.println(id+"--"+name);
        }

        rs.close();
        stat.close();
        conn.close();
        System.out.println("执行成功");
    }catch (SQLException e){
        e.printStackTrace();
    }
}

}