Dao设计模式简单实例

DAO设计模式就是将数据层与业务层分离，使开发更加方便，提高程序的可移植性。

package com.neusoft.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class DbCon {
//打开，关闭数据库，执行增删改数据的操作
	protected Connection conn;
	protected Statement stmt;
	protected ResultSet rs;
	public void open() 
	{
		try {
			Class.forName("com.mysql.jdbc.Driver");
			conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3308/demo1","root","root");
			stmt=conn.createStatement();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			System.out.println("打开数据库失败");
		}
	}
	public int update(String sql)
	{
		try{
			int row=stmt.executeUpdate(sql);
			return row;
		}catch(Exception e){
			return -1;
		}
	}
	public void close()
	{
		try {
			if(rs!=null){
				rs.close();
				}
			if(stmt!=null){
			stmt.close();
				}
			if(conn!=null){
				conn.close();
				}
			}catch (Exception e) {
			// TODO Auto-generated catch block
			System.out.println("关闭数据库错误");
			}
		}
	}

package com.neusoft.dao;

public class DeptDAO extends DbCon{
	public void select(String sql)
	{
		try{
			rs=stmt.executeQuery(sql);
			while(rs.next())
			{
				System.out.println(rs.getInt("deptno")+","+rs.getString("dname")+","+rs.getString("loc"));
			}
		}catch(Exception e){
			System.out.println("查询dept表失败！");
		}
		
	}
}

package com.neusoft.entity;

public class Dept {
	private Integer deptno;
	private String dname;
	private String loc;
	public Integer getDeptno() {
		return deptno;
	}
	public void setDeptno(Integer deptno) {
		this.deptno = deptno;
	}
	public String getDname() {
		return dname;
	}
	public void setDname(String dname) {
		this.dname = dname;
	}
	public String getLoc() {
		return loc;
	}
	public void setLoc(String loc) {
		this.loc = loc;
	}
	
}

package com.neusoft.service;

import java.util.Scanner;

import com.neusoft.dao.DeptDAO;

public class DeptService {
	public void select()
	{
		DeptDAO dao=new DeptDAO();
		dao.open();
		dao.select("select * from dept");
		dao.close();
	}
	public void insert()
	{
		DeptDAO dao=new DeptDAO();		
		Scanner input=new Scanner(System.in);
		int deptno;
		String dname,loc,sql;
		System.out.println("插入一条dept表记录");
		System.out.println("请输入deptno:");
		deptno=input.nextInt();
		System.out.println("请输入dnaem:");
		dname=input.next();
		System.out.println("请输入loc:");
		loc=input.next();
		sql="insert into dept values("+deptno+",'"+dname+"','"+loc+"')";
		dao.open();
		int row=dao.update(sql);
		if(row>=1)
		{
			System.out.println("插入记录成功");
		}
		dao.close();
	}
}

package com.neusoft.service;

import java.util.Scanner;

//主程序（界面）
public class MainService {
	public static void main(){
		System.out.println("欢迎使用部门管理系统");
		DeptService s=new DeptService();
		while(true){
			int no;
			Scanner input =new Scanner(System.in);
			System.out.println("1 查询部门");
			System.out.println("2 插入部门");
			System.out.println("3 退出");
			System.out.println("3 请输入（1-3）");
			no=input.nextInt();
			if(no==1){
				s.select();
			}else if(no==2){
				s.insert();
			}else if(no==3){
				break;
			}
		}
	}
}

package com.neusoft.test;

import com.neusoft.service.MainService;

public class Test {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		MainService.main();
	}

}