实验四：JDBC访问数据库

一、实验目的：

理解JDBC的工作原理，掌握JDBC访问数据库;
掌握常见数据库MYSQL;

二、实验环境：

MYSQL,Eclipse

三、实验内容：
(写出主要的内容)
1、设计数据库表

CREATE TABLE
    tbl_user_info
    (
        id INT NOT NULL AUTO_INCREMENT,
        user_name VARCHAR(20) NOT NULL,
        age INT NOT NULL,
        sex INT(1) NOT NULL,
        create_dt DATE NOT NULL,
        PRIMARY KEY (id)
    )
    ENGINE=InnoDB DEFAULT CHARSET=utf8;
insert into tbl_user_info values('4','Mary','25','0','2016-06-24');
insert into tbl_user_info values('5','Jack','22','1','2016-06-24');
insert into tbl_user_info values('6','John','19','1','2016-06-24')

结果：

2、定义实体类

package com.imooc.jdbc;
 
import java.util.Date;
 
public class UserVO {
   
	private int id;
	private String userName;
	private int age;
	private int sex;
	private Date createDt;
 
	public int getId() {
   
		return id;
	}
 
	public void setId(int id) {
   
		this.id = id;
	}
 
	public String getUserName() {
   
		return userName;
	}
 
	public void setUserName(String userName) {
   
		this.userName = userName;
	}
 
	public int getAge() {
   
		return age;
	}
 
	public void setAge(int age) {
   
		this.age = age;
	}
 
	public int getSex() {
   
		return sex;
	}
 
	public void setSex(int sex) {
   
		this.sex = sex;
	}
 
	public Date getCreateDt() {
   
		return createDt;
	}
 
	public void setCreateDt(Date createDt) {
   
		this.createDt = createDt;
	}
 
	@Override
	public String toString() {
   
		return "UserVO [id=" + id + ", userName=" + userName + ", age=" + age
				+ ", sex=" + sex + ", createDt=" + createDt + "]";
	}
 
}

3、定义数据库连接类

package com.imooc.jdbc;