JDBC学习笔记（二）

构建一个小程序以实现JDBC，参照课程：幕客网JDBC课程。

项目采用MVC三层架构，试图，控制，模型

1.首先，建立模型层

import java.util.Date;

public class Goddess {
 private Integer id;
 private String user_name;
 private Integer sex;
 private Integer age;
 private Date birthdaty;
 private String emil;
 private String mobile;
 private String create_user;
 private String update_user;
 private Date create_date;
 private Date  update_date;
 private Integer isdel;

	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	public String getUser_name() {
		return user_name;
	}

	public void setUser_name(String user_name) {
		this.user_name = user_name;
	}

	public Integer getSex() {
		return sex;
	}

	public void setSex(Integer sex) {
		this.sex = sex;
	}

	public Integer getAge() {
		return age;
	}

	public void setAge(Integer age) {
		this.age = age;
	}

	public Date getBirthdaty() {
		return birthdaty;
	}

	public void setBirthdaty(Date birthdaty) {
		this.birthdaty = birthdaty;
	}

	public String getEmil() {
		return emil;
	}

	public void setEmil(String emil) {
		this.emil = emil;
	}

	public String getMobile() {
		return mobile;
	}

	public void setMobile(String mobile) {
		this.mobile = mobile;
	}

	public String getCreate_user() {
		return create_user;
	}

	public void setCreate_user(String create_user) {
		this.create_user = create_user;
	}

	public String getUpdate_user() {
		return update_user;
	}

	public void setUpdate_user(String update_user) {
		this.update_user = update_user;
	}

	public Date getCreate_date() {
		return create_date;
	}

	public void setCreate_date(Date create_date) {
		this.create_date = create_date;
	}

	public Date getUpdate_date() {
		return update_date;
	}

	public void setUpdate_date(Date update_date) {
		this.update_date = update_date;
	}

	public Integer getIsdel() {
		return isdel;
	}

	public void setIsdel(Integer isdel) {
		this.isdel = isdel;
	}
 
}

将数据库中的各项参数建立在java中对应的变量，并写出他们的get和set方法。

2.建立与数据库的连接——DAO层

连接数据库之后，进行在java层面上的对数据的查询

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import com.imooc.db.DBUtil;
import com.imooc.model.Goddess;

public class goddessDao {
 public void addGoddess(){
	 Connection conn= DBUtil.getConnection();
 }
 public void updateGoddess(){
	 
 }
 public void delGoddess(){
	 
 }
 public List<Goddess> query() throws Exception{
	 Connection conn= DBUtil.getConnection();
	 Statement stmt=conn.createStatement();
		ResultSet rs=stmt.executeQuery("select user_name,age from imooc_goddess");
		List<Goddess> gs=new ArrayList<Goddess>();
		Goddess g=null;
		while(rs.next()){
			g=new Goddess();
			g.setUser_name(rs.getString("user_name"));
			g.setAge(rs.getInt("age"));
			gs.add(g);
			
		}
		return gs;
 }
 public Goddess get(){
	 return null;
 }
}

3.建立控制层

import java.util.List;

import com.imooc.dao.goddessDao;
import com.imooc.model.Goddess;

public class GoddessAction {
public static void main(String[] args) throws Exception {
	goddessDao g=new goddessDao();
	List<Goddess> gs=g.query();
	for(Goddess goddess:gs){
		System.out.println(goddess.getUser_name()+","+goddess.getAge());
	}
}
}

作为程序的入口，输出程序结果