JDBC - 改进的CURD（04）

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import org.junit.Test;

import com.utils.JDBCUtil;

public class AdvancedCURD {

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

    @Test
    public void query() throws Exception {
        String sql = "select * from students where id=?";
        PreparedStatement ps = con.prepareStatement(sql);
        ps.setString(1, "160341238");
        ResultSet query = ps.executeQuery();
        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 {
        String sql = "insert into students(id, name, clazz) values (?, ?, ?)";
        PreparedStatement ps = con.prepareStatement(sql);
        ps.setString(1, "160341244");
        ps.setString(2, "qwe");
        ps.setString(3, "160341B");
        int row = ps.executeUpdate();
        System.out.println(row);
    }

    @Test
    public void update() throws Exception {
        String sql = "update students set id = ? where id = ?";
        PreparedStatement ps = con.prepareStatement(sql);
        ps.setString(1, "helloworld");
        ps.setString(2, "160341243");
        int row = ps.executeUpdate();

    }

    @Test
    public void delete() throws Exception {
        String sql = "delete from students where id = ?";
        PreparedStatement ps = con.prepareStatement(sql);
        ps.setString(1, "160341238");
        int row = ps.executeUpdate();
        //返回处理的行数
        System.out.println(row);
    }

}