增删改查通过工具类实现
package com.emp.entity;
public class Emp {
private String empno;
private String empname;
private String empsex;
private int empage;
private String hiredate;
private int salary;
private String deptid;
private Dept dept = new Dept();
public Dept getDept() {
return dept;
}
public void setDept(Dept dept) {
this.dept = dept;
}
public Emp(String empno, String empname, String empsex, int empage, String hiredate, int salary, String deptid, Dept dept) {
this.empno = empno;
this.empname = empname;
this.empsex = empsex;
this.empage = empage;
this.hiredate = hiredate;
this.salary = salary;
this.deptid = deptid;
this.dept = dept;
}
public Emp() {
}
public String getEmpno() {
return empno;
}
public void setEmpno(String empno) {
this.empno = empno;
}
public String getEmpname() {
return empname;
}
public void setEmpname(String empname) {
this.empname = empname;
}
public String getEmpsex() {
return empsex;
}
public void setEmpsex(String empsex) {
this.empsex = empsex;
}
public int getEmpage() {
return empage;
}
public void setEmpage(int empage) {
this.empage = empage;
}
public String getHiredate() {
return hiredate;
}
public void setHiredate(String hiredate) {
this.hiredate = hiredate;
}
public int getSalary() {
return salary;
}
public void setSalary(int salary) {
this.salary = salary;
}
public String getDeptid() {
return deptid;
}
/**
* 修改了该方法 给dept的deptid赋值
* @param deptid
*/
public void setDeptid(String deptid) {
this.deptid = deptid;
this.dept.setDeptid(deptid);
}
/**
* 新增的方法，是为了给dept对象属性进行赋值
*
* @param deptname
*/
public void setDeptname(String deptname) {
this.dept.setDeptname(deptname);
}
/**
* 新增的方法，是为了给dept对象属性进行赋值
*
* @param deptinfo
*/
public void setDeptinfo(String deptinfo) {
this.dept.setDeptinfo(deptinfo);
}
@Override
public String toString() {
return "Emp{" +
"empno='" + empno + '\'' +
", empname='" + empname + '\'' +
", empsex='" + empsex + '\'' +
", empage=" + empage +
", hiredate='" + hiredate + '\'' +
", salary=" + salary +
", deptid='" + deptid + '\'' +
'}';
}
}
package com.emp.entity;
public class Dept {
private String deptid;
private String deptname;
private String deptinfo;
public Dept() {
}
public Dept(String deptid, String deptname, String deptinfo) {
this.deptid = deptid;
this.deptname = deptname;
this.deptinfo = deptinfo;
}
public String getDeptid() {
return deptid;
}
public void setDeptid(String deptid) {
this.deptid = deptid;
}
public String getDeptname() {
return deptname;
}
public void setDeptname(String deptname) {
this.deptname = deptname;
}
public String getDeptinfo() {
return deptinfo;
}
public void setDeptinfo(String deptinfo) {
this.deptinfo = deptinfo;
}
@Override
public String toString() {
return "dept{" +
"deptid='" + deptid + '\'' +
", deptname='" + deptname + '\'' +
", deptinfo='" + deptinfo + '\'' +
'}';
}
}
package com.emp.dao;
import com.emp.entity.Emp;
import com.emp.util.Util;
import java.util.List;
/**
* empdao
*/
public class EmpDao extends Util {
DeptDao deptDao = new DeptDao();
/**
* 增加
*
* @param emp
* @return int 1 0失败
*/
public int empAdd(Emp emp) {
String sql = "INSERT INTO emp VALUES('?','?','?','?','?','?','?');";
return exEdit(sql,
emp.getDeptid(),
emp.getEmpname(),
emp.getEmpsex(),
emp.getEmpage(),
emp.getHiredate(),
emp.getSalary(),
emp.getDeptid());
}
/**
* 查询所有数据
*
* @return list
*/
public List<Emp> getAll() {
String sql =
"SELECT dept.deptid,dept.deptname,dept.deptinfo,emp.empno,emp.empname,emp.empsex,emp.empage,emp.hiredate,emp.salary FROM dept INNER JOIN emp ON dept.deptid=emp.deptid";
List<Emp> list = exQuery(sql, Emp.class, null);
return list;
}
/**
* 查询单个数据
* @param id
* @return list
*/
public Emp getEmpBy(String id) {
Emp emp = null;
String sql =
"SELECT * FROM emp WHERE empno = ?";
List<Emp> list = exQuery(sql, Emp.class, id);
if (list.size() != 0) {
emp = list.get(0);
}
return emp;
}
/**
* 根据部门编号查询
* @param id
* @return List<Emp>
*/
public List<Emp> getDeptId(int id) {
String sql =
"SELECT * FROM emp WHERE emp.deptid = ?";
List<Emp> list = exQuery(sql, Emp.class, id);
return list;
}
/**
* 修改
*
* @param emp
* @return int 0未修改
*/
public int updataEmp(Emp emp) {
String sql =
"UPDATE emp SET empname=?,empsex=?,empage=?,hiredate=?,salary=? WHERE empno = ?;";
return exEdit(sql,
emp.getEmpname(),
emp.getEmpsex(),
emp.getEmpage(),
emp.getHiredate(),
emp.getSalary(),
emp.getEmpno());
}
/**
* 删除
*
* @param id
* @return int 0未删除
*/
public int delete(String id) {
String sql = "Delete from emp where empno = ?";
return exEdit(sql, id);
}
}
package com.emp.dao;
import com.emp.entity.Dept;
import com.emp.util.Util;
import java.util.List;
public class DeptDao extends Util {
/**
* 添加
*
* @param dept
* @return int 1 0失败
*/
public int deptAdd(Dept dept) {
String sql = "INSERT INTO dept VALUES('?','?','?');";
return exEdit(sql, dept.getDeptid(), dept.getDeptname(), dept.getDeptinfo());
}
/**
* 删除
*
* @param id
* @return int 1 0失败
*/
public int deptDelete(String id) {
String sql = "Delete from dept where empno = ?";
return exEdit(sql, id);
}
/**
* 修改
*
* @param dept
* @return int 1 0失败
*/
public int updataEmp(Dept dept) {
String sql =
"UPDATE emp SET deptname=?,deptinfo=? WHERE deptid = ?;";
return exEdit(sql, dept.getDeptname(), dept.getDeptinfo(), dept.getDeptid());
}
/**
* 查询全部
*
* @return list
*/
public List<Dept> getAll() {
String sql = "SELECT dept.* FROM dept";
List<Dept> list = exQuery(sql, Dept.class, null);
return list;
}
/**
* 根据Id查询
*
* @param id
* @return
*/
public Dept getDeptById(String id) {
String sql = "SELECT * FROM dept WHERE deptid=?";
List<Dept> list = exQuery(sql, Dept.class, id);
if (list.size() == 0) {
return null;
} else {
return list.get(0);
}
}
}
package com.emp.test;
import com.emp.dao.DeptDao;
import com.emp.dao.EmpDao;
import com.emp.entity.Dept;
import com.emp.entity.Emp;
import org.junit.Test;
import java.util.List;
public class EmpDaoTest {
@Test
public void empAdd() {
Dept dept = new Dept();
EmpDao empDao = new EmpDao();
Emp emp =
new Emp("","","",12,"",2333,dept.getDeptid(),dept);
empDao.empAdd(emp);
}
@Test
public void getEmpBy() {
EmpDao empDao = new EmpDao();
DeptDao deptDao = new DeptDao();
Emp emp = empDao.getEmpBy("A101");
emp.setDept(deptDao.getDeptById(emp.getDeptid()));
System.out.println(emp+", "+emp.getDept());
}
@Test
public void updataEmp() {
}
@Test
public void delete() {
}
@Test
public void getAllEmpDao1(){
EmpDao empDao = new EmpDao();
Dept dept = new Dept();
List<Emp> list = empDao.getAll();
for (Emp e : list) {
System.out.println(e+","+e.getDept());
}
}
@Test
public void getDeptId(){
EmpDao empDao = new EmpDao();
Dept dept = new Dept();
List<Emp> list = empDao.getDeptId(1);
for (Emp e : list) {
System.out.println(e.getDept());
}
}
}
import com.emp.dao.EmpDao;
import com.emp.entity.Dept;
import com.emp.entity.Emp;
import org.junit.Test;
import java.util.List;
public class EmpDaoTest {
@Test
public void getAllEmpDao1(){
EmpDao empDao = new EmpDao();
Dept dept = new Dept();
List<Emp> list = empDao.getAll();
for (Emp e : list) {
System.out.println(e+","+e.getDept());
}
}
}
