mysql之java操作

添加数据

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

public class MYSQLInsert {
    public static void main(String[] args) throws Exception{
        //1.加载驱动
        Class.forName("com.mysql.jdbc.Driver");
        //2.获取连接
        Connection conn = DriverManager.getConnection("jdbc:mysql://master:3306/test", "root", "123456");
        //3.执行sql
        String sql="insert into student(id,name,age,sex) values(1014,'yyy',18,'0')";
        Statement statement = conn.createStatement();
        int i = statement.executeUpdate(sql);
        System.out.println(i);
        //4.关闭
        statement.close();
        conn.close();

    }
}

删除数据

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

public class MYSQLDelete {
    public static void main(String[] args) throws Exception{
        //1.加载驱动
        Class.forName("com.mysql.jdbc.Driver");
        //2.获取连接
        Connection conn = DriverManager.getConnection("jdbc:mysql://master:3306/shujia", "root", "123456");
        Statement statement = conn.createStatement();
        String sql="delete from student where id=1014";
        int i = statement.executeUpdate(sql);
        System.out.println(i);
        statement.close();
        conn.close();
    }
}

改数据

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

public class MYSQLUpdate {
    public static void main(String[] args) throws Exception {
        // 1.加载驱动
        Class.forName("com.mysql.jdbc.Driver");
        //2.获取连接
        Connection conn = DriverManager.getConnection("jdbc:mysql://master/test", "root", "123456");
        //3.执行sql
        String sql ="update student set name ='update'where id =1013";

        Statement statement = conn.createStatement();
        int i = statement.executeUpdate(sql);
        System.out.println(i);
        //4关闭流
        statement.close();
        conn.close();
    }
}

查数据

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

public class MysqlTest {
    public static void main(String[] args) throws Exception {
        Class.forName("com.mysql.jdbc.Driver");
       Connection conn = DriverManager.getConnection("jdbc:mysql://master/test","root","123456");
       String sql ="select * from emp";
        Statement statement = conn.createStatement();
        ResultSet resultSet = statement.executeQuery(sql);
        while (resultSet.next()) {
            String name =resultSet.getString(3);
            System.out.println(name);
        }
resultSet.close();
        statement.close();
        conn.close();

    }
}