个人简历管理系统（5）-Dao

UserDao

业务逻辑分析

业务逻辑	Dao层方法
用户登录	check
用户注册（先判断用户名是否存在，再添加）	checkId+add
修改密码	update

源代码

package com.resume.dao;


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

import com.resume.bean.User;
import com.resume.jdbc.jdbc;

public class UserDao {
	
	public void add(String id,String password) {
		String sql = "insert  into user values('"+id+"','"+password+"');";
		Connection connection= jdbc.getConn();
		Statement statement = null;
		try {
			statement= connection.createStatement();
			statement.executeUpdate(sql);
		} catch (Exception e) {
			e.printStackTrace();
		}finally {
			jdbc.close(connection, statement, null);
		}
	}
	
	public User check(String id,String password) {
		User user = null;
		String sql ="select * from user where userid= '"+id+"'and password='"+password+"';";
		Connection connection= jdbc.getConn();
		Statement statement = null;
		ResultSet resultSet = null;
		try {
			statement= connection.createStatement();
			resultSet = statement.executeQuery(sql);
			if(resultSet.next())user = new User(id,password);
		} catch (Exception e) {
			e.printStackTrace();
		}finally {
			jdbc.close(connection, statement, resultSet);
		}
		return user;
	}
	
	public User checkId(String id) {
		User user = null;
		String sql ="select * from user where userid= '"+id+"';";
		Connection connection= jdbc.getConn();
		Statement statement = null;
		ResultSet resultSet = null;
		try {
			statement= connection.createStatement();
			resultSet = statement.executeQuery(sql);
			if(resultSet.next())user=new User(id,resultSet.getString(2));
		} catch (Exception e) {
			e.printStackTrace();
		}finally {
			jdbc.close(connection, statement, resultSet);
		}
		return user;
	}
	
	public void update(User user) {
		String sql ="update user set password='"+user.getPassword()+"' where userid='"+user.getUserid()+"';";
		Connection connection= jdbc.getConn();
		Statement statement = null;
		ResultSet resultSet = null;
		try {
			statement= connection.createStatement();
			statement.executeUpdate(sql);
		} catch (Exception e) {
			e.printStackTrace();
		}finally {
			jdbc.close(connection, statement, resultSet);
		}
	}
	
	//测试
	public static void main(String []args) {
		 UserDao userDao = new UserDao();
		 userDao.add("1", "123");
		 User user =userDao.check("1", "123");
		 System.out.println(user);
		 user.setPassword("123456");
		 userDao.update(user);
		 user = userDao.checkId(user.getUserid());
		 System.out.println(user);
	}
}

测试截图

ResumeDao

业务逻辑分析

业务逻辑	Dao层方法
添加简历	add
修改简历	update
删除简历	delete
计算查询的结果数	count
得到某一用户所有的简历id	getAll
通过id得到简历信息	getById

源代码

package com.resume.dao;

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

import com.resume.jdbc.jdbc;
import com.resume.bean.Resume;

public class ResumeDao {

	public void add(Resume resume) {
		String sql = " insert into resume(username,sex,birth,ethnic,native,politic,mayor,school,telephone,email,skill,experience,evaluation,userid) ";
		sql += "values('" + resume.getUsername() + "','" + resume.getSex();
		sql += "','" + resume.getBirth() + "','" + resume.getEthnic() + "','" + resume.get_native() + "','";
		sql += resume.getPolitic() + "','" + resume.getMayor() + "','" + resume.getSchool() + "','"
				+ resume.getTelephone() + "','";
		sql += resume.getEmail() + "','" + resume.getSkill() + "','" + resume.getExperience() + "','"
				+ resume.getEvaluation() + "','" + resume.getUserid() + "');";
		Connection connection = jdbc.getConn();
		Statement statement = null;
		try {
			statement = connection.createStatement();
			statement.executeUpdate(sql);
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			jdbc.close(connection, statement, null);
		}
	}

	public void update(Resume resume) {
		String sql = " update resume set";
		sql += " username='" + resume.getUsername() + "',";
		sql += " sex='" + resume.getSex() + "',";
		sql += " birth='" + resume.getBirth() + "',";
		sql += " ethnic='" + resume.getEthnic() + "',";
		sql += " native='" + resume.get_native() + "',";
		sql += " politic='" + resume.getPolitic() + "',";
		sql += " mayor='" + resume.getMayor() + "',";
		sql += " school='" + resume.getSchool() + "',";
		sql += " telephone='" + resume.getTelephone() + "',";
		sql += " email='" + resume.getEmail() + "',";
		sql += " skill='" + resume.getSkill() + "',";
		sql += " experience='" + resume.getExperience() + "',";
		sql += " evaluation='" + resume.getEvaluation() + "'; ";
		sql += " where id='" + resume.getId() + "';";
		Connection connection = jdbc.getConn();
		Statement statement = null;
		try {
			statement = connection.createStatement();
			statement.executeUpdate(sql);
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			jdbc.close(connection, statement, null);
		}
	}

	public void delete(String id) {
		String sql = "delete from resume where id='" + id + "';";
		Connection connection = jdbc.getConn();
		Statement statement = null;
		try {
			statement = connection.createStatement();
			statement.executeUpdate(sql);
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			jdbc.close(connection, statement, null);
		}
	}

	public int count(String sql) {
		int a = 0;
		Connection connection = jdbc.getConn();
		Statement statement = null;
		ResultSet resultSet = null;
		try {
			statement = connection.createStatement();
			resultSet = statement.executeQuery(sql);
			if(resultSet.next())a = resultSet.getInt(1);
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			jdbc.close(connection, statement, null);
		}
	    return a;
	}

	public Resume getById(String id) {
		Resume resume = null;
		String sql = "select * from resume where id='"+id+"';";
		Connection connection = jdbc.getConn();
		Statement statement = null;
		ResultSet resultSet = null;
		try {
			statement = connection.createStatement();
			resultSet = statement.executeQuery(sql);
			if(resultSet.next())resume  = new Resume( resultSet.getInt(1),resultSet.getString(2),
					resultSet.getString(3),resultSet.getString(4),resultSet.getString(5),resultSet.getString(6),
					resultSet.getString(7),resultSet.getString(8),resultSet.getString(9),resultSet.getString(10),
					resultSet.getString(11),resultSet.getString(12),resultSet.getString(13),resultSet.getString(14),
					resultSet.getString(15));
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			jdbc.close(connection, statement, null);
		}
	    return resume;
	}
	
	public List<Integer> getAll(String userid){
		List <Integer> list = new ArrayList<Integer>();
		String sql = "select id from resume where userid='"+userid+"';";
		Connection connection = jdbc.getConn();
		Statement statement = null;
		ResultSet resultSet = null;
		try {
			statement = connection.createStatement();
			resultSet = statement.executeQuery(sql);
			while(resultSet.next()){
				list.add(resultSet.getInt(1));
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			jdbc.close(connection, statement, null);
		}
	    return list;
	}
}

备注

• 项目相关博客
  个人简历管理系统（1）-数据库创建
  个人简历管理系统（2）-数据库连接
  个人简历管理系统（3）- 登陆与注册界面
  个人简历管理系统（4）-javaBean层

参考博客
用eclipse创建一个javaweb项目