录入学员信息

环境准备：
包结构：

======================
student.java

package com.atguigu.jdbc;public class Student {    private Integer id;    private int type;    private String idCard;    private String examCard;    private String studentName;    private String location;    private int grade;    public Student() {        // TODO Auto-generated constructor stub    }    public Student(Integer id, int type, String idCard, String examCard,            String studentName, String location, int grade) {        this.id = id;        this.type = type;        this.idCard = idCard;        this.examCard = examCard;        this.studentName = studentName;        this.location = location;        this.grade = grade;    }    public Integer getId() {        return id;    }    public void setId(Integer id) {        this.id = id;    }    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 "Student [id=" + id + ", type=" + type + ", idCard=" + idCard                + ", examCard=" + examCard + ", studentName=" + studentName                + ", location=" + location + ", grade=" + grade + "]";    }}===============================================db.properties

jdbc.user=root
jdbc.password=1230
jdbc.driverClass=com.mysql.jdbc.Driver
jdbc.jdbcUrl=jdbc:mysql:///jdbc
//jdbc.jdbcUrl=jdbc:mysql://127.0.0.1/jdbc
/*
jdbc.user=atguigu
jdbc.password=atguigu
jdbc.driverClass=oracle.jdbc.driver.OracleDriver
jdbc.jdbcUrl=jdbc:oracle:thin:@127.0.0.1:1521:orcl
*/

数据库表：

=========================
第一步：
编写工具类：
JdbcUtils.java

package com.atguigu.jdbc;import java.io.InputStream;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.util.Properties;public class JdbcUtils {    public static void closeConnection(Connection connection){        if(connection != null){            try {                connection.close();            } catch (SQLException e) {                e.printStackTrace();            }        }    }    //从数据库连接池中获取连接    public static Connection getConnection2() throws Exception{        return dataSource.getConnection();    }    public static Connection getConnection() throws Exception{        //1. 加载资源文件        Properties properties = new Properties();        InputStream inStream = JdbcUtils.class.getClassLoader().getResourceAsStream("db.properties");        properties.load(inStream);        //2. 获取数据库连接需要的四个基本信息:        String user = properties.getProperty("jdbc.user");        String password = properties.getProperty("jdbc.password");        String driverClass = properties.getProperty("jdbc.driverClass");        String jdbcUrl = properties.getProperty("jdbc.jdbcUrl");        //3. 加载驱动        Class.forName(driverClass);        //4. 从 DriverManager 中来获取连接        Connection connection = DriverManager.getConnection(jdbcUrl, user, password);        return connection;    }}

======================
第二步：
测试数据库连接并录入学员信息：
JdbcTest.java

package com.atguigu.jdbc.test;import java.io.IOException;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.Scanner;import org.apache.commons.dbutils.DbUtils;import org.apache.commons.dbutils.QueryRunner;import org.apache.commons.dbutils.ResultSetHandler;import org.junit.Test;import com.atguigu.jdbc.JdbcUtils;import com.atguigu.jdbc.Student;import com.atguigu.jdbc.StudentDao;public class JdbcTest {    @Test    public void testGetConnection() throws Exception {        Connection connection = JdbcUtils.getConnection();        System.out.println(connection);    }    /**     * Dao: Database Access Object, 即数据库访问对象. 把根数据库相关的所有操作(CRUD)都封装在这样的一个类中.     *      * @throws Exception     * @throws SQLException     */    @Test    public void testSaveStudent() throws SQLException, Exception {        // 1. 从控制台输入一组数据, 转为一个 Student 对象        System.out.println("请输入考生的详细信息:");        Student student = getFromConsole();        // 2. 调用 StudentDao 中的一个方法.        StudentDao studentDao = new StudentDao();        studentDao.save(student);        System.out.println("信息录入成功!");    }    private Student getFromConsole() {        Scanner scanner = new Scanner(System.in);        System.out.println("type:");        int type = scanner.nextInt();        System.out.println("IdCard:");        String idCard = scanner.next();        System.out.println("ExamCard:");        String examCard = scanner.next();        System.out.println("StudentName:");        String studentName = scanner.next();        System.out.println("Location:");        String location = scanner.next();        System.out.println("Grade:");        int grade = scanner.nextInt();        Student student = new Student(null, type, idCard, examCard,                studentName, location, grade);        return student;    }}

==================================

StudentDao.java

package com.atguigu.jdbc;import java.sql.SQLException;import org.apache.commons.dbutils.QueryRunner;import org.apache.commons.dbutils.handlers.BeanHandler;/** * StudentDao: Student 这个实体类和 Student 实体类对应的数据表的 数据库访问对象(DAO) 类 * 其中只包含对数据表的操作, 例如 CRUD。但不包含任何的业务逻辑. */public class StudentDao {    //QueryRunner 是线程安全的!    private QueryRunner queryRunner = new QueryRunner();    public void save(Student student) throws SQLException, Exception{        String sql = "INSERT INTO examstudent(type, id_card, exam_card, "                + "student_name, location, grade) VALUES(?,?,?,?,?,?)";        queryRunner.update(JdbcUtils.getConnection(), sql, student.getType(),                student.getIdCard(), student.getExamCard(), student.getStudentName(),                 student.getLocation(), student.getGrade());    }}

未完待续！