JDBC - CURD（02）

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

import org.junit.Test;

import com.utils.JDBCUtil;

public class CRUD {

    static Connection con;
    static {
        con = JDBCUtil.getConn();
    }

    @Test
    public void query() throws Exception {
        Statement statement = con.createStatement();
        String sql = "select * from students";
        ResultSet query = statement.executeQuery(sql);
        while(query.next()){
            String id = query.getString("id");
            String name = query.getString("name");
            String clazz = query.getString("clazz");
            System.out.println(id + "  " + name + "  " + clazz);
        }
    }

    @Test
    public void insert() throws Exception {
        Statement statement = con.createStatement();
        String sql = "insert into students(id, name, clazz) values ('160341238', '赵承阳', '160341B')";
        int row = statement.executeUpdate(sql);
    }

    @Test
    public void update() throws Exception {
        Statement statement = con.createStatement();
        String sql = "update students set id = 'helloworld' where id = '160341237'";
        int row = statement.executeUpdate(sql);
    }

    @Test
    public void delete() throws Exception {
        Statement statement = con.createStatement();
        String sql = "delete from students where id = '160341238'";
        //返回处理的行数
        int row = statement.executeUpdate(sql); 
    }
}