实验四 JDBC访问数据库

一、实验目的：
1.理解JDBC的应用
2.掌握JDBC的编程接口。
3.熟练使用MYEclipse开发简单应用工作原理，掌握JDBC访问数据库；掌握常见数据库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,
PRIMART KEY(id)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8;

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;
	}
	public String toString() {
   
		return "UserVO[id="+id+",userName="+userName+",age="+age+",sex="+sex+",createDt="+createDt+"]";
	}
}

3.定义数据库连接类

package com.imooc.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;

public class DBUtil {
   
	private static final String URI="jdbc:mysql://127.0.0.1:3306/test?"
			+"user=root&password=123456&useUnicode=true&characterEncoding=UTF-8";
	private static final String DRIVER="com.mysql.jdbc.Driver";
	public static Connection connectDB()throws Exception{
   
		Class.forName(DRIVER);
		Connection conn=DriverManager.getConnection(URI);
		
		return conn;
	}
}

4.实现数据库的增删改查
（1）查询

import java.sql.Connection;
import