随便写了一个DAO

package com.java;

public class ExamStudent {
    /**
     * 流水号
     */
    private int flowId;

    /**
     * 四级、六级
     */
    private int type;

    /**
     * 身份证号码
     */
    private String idCard;

    /**
     * 准考证号码
     */
    private String examCard;

    /**
     * 学生姓名
     */
    private String studentName;

    /**
     * 区域
     */
    private String location;

    /**
     * 成绩
     */
    private int grade;

    public int getFlowId() {
        return flowId;
    }

    public void setFlowId(int flowId) {
        this.flowId = flowId;
    }

    public int getType() {
        return type;
    }

    public void setType(int type) {
        this.type = type;
    }

    public String getIdCard() {
        return idCard;
    }

    public void setIdCard(String idCard) {
        this.idCard = idCard;
    }

    public String getExamCard() {
        return examCard;
    }

    public void setExamCard(String examCard) {
        this.examCard = examCard;
    }

    public String getStudentName() {
        return studentName;
    }

    public void setStudentName(String studentName) {
        this.studentName = studentName;
    }

    public String getLocation() {
        return location;
    }

    public void setLocation(String location) {
        this.location = location;
    }

    public int getGrade() {
        return grade;
    }

    public void setGrade(int grade) {
        this.grade = grade;
    }

    @Override
    public String toString() {
        return "ExamStudent [flowId=" + flowId + ", type=" + type + ", idCard=" + idCard + ", examCard=" + examCard
                + ", studentName=" + studentName + ", location=" + location + ", grade=" + grade + "]";
    }
    
}

package com.java;

import org.junit.Test;

public class DaoTest {
    Dao dao = new Dao();
    @Test
    public void testUpdate() {
        String sql = "INSERT INTO customers (name,email,birth)"
                + "VALUES (?,?,?)";
        dao.update(sql, "小明","xiaoming@live.com",
                new java.sql.Date(new java.util.Date().getTime()));
    }

    @Test
    public void testGetOne() {
        String sql = "SELECT flow_id flowId,type type,id_card idCard"
                + ",exam_card examCard,student_name studentName,location location,"
                + "grade grade FROM exam_student";
        ExamStudent student = new ExamStudent();
        dao.getOne(student.getClass(), sql);
        
        System.out.println(student);
    }

    @Test
    public void testGetForList() {
    }

    @Test
    public void testGetForValue() {
    }

}

创建表的ddl

/*
SQLyog Ultimate v10.42 
MySQL - 5.5.28 : Database - dic
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`dic` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `dic`;

/*Table structure for table `customers` */

DROP TABLE IF EXISTS `customers`;

CREATE TABLE `customers` (
  `ID` int(6) NOT NULL AUTO_INCREMENT,
  `NAME` varchar(25) DEFAULT NULL,
  `EMAIL` varchar(25) DEFAULT NULL,
  `BIRTH` date DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

/*Data for the table `customers` */

insert  into `customers`(`ID`,`NAME`,`EMAIL`,`BIRTH`) values (2,'李小龙','long@live.com','1940-11-27'),(3,'成龙','cheng@163.com','1978-04-25'),(4,'小明','xiaoming@live.com','2016-09-28');

/*Table structure for table `exam_student` */

DROP TABLE IF EXISTS `exam_student`;

CREATE TABLE `exam_student` (
  `FLOW_ID` int(20) NOT NULL AUTO_INCREMENT COMMENT '流水号',
  `TYPE` int(6) DEFAULT NULL COMMENT '四级/六级',
  `ID_CARD` varchar(18) DEFAULT NULL COMMENT '身份证号码',
  `EXAM_CARD` varchar(15) DEFAULT NULL COMMENT '准考证号码',
  `STUDENT_NAME` varchar(20) DEFAULT NULL COMMENT '学生姓名',
  `LOCATION` varchar(20) DEFAULT NULL COMMENT '区域',
  `GRADE` int(6) DEFAULT NULL COMMENT '成绩',
  KEY `FLOW_ID` (`FLOW_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

/*Data for the table `exam_student` */

insert  into `exam_student`(`FLOW_ID`,`TYPE`,`ID_CARD`,`EXAM_CARD`,`STUDENT_NAME`,`LOCATION`,`GRADE`) values (1,4,'412824195263214584','200523164754000','张峰','郑州',85),(2,4,'222224195263214584','200523164754001','孙朋','大连',56),(3,6,'342824195263214584','200523164754002','刘明','沈阳',72),(4,6,'100824195263214584','200523164754003','赵虎','哈尔滨',95),(5,4,'454524195263214584','200523164754004','杨丽','北京',64),(6,4,'854524195263214584','200523164754005','王小红','太原',60),(7,4,'5','6','7','8',9),(8,23,'24','25','26','27',28),(9,77,'88','99','1010','1111',1212),(10,1,'2','3','4','5',6),(11,23,'45','56','67','78',89);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;