使用jdbc完成数据库的增删改查【员工管理系统】

最新推荐文章于 2021-04-22 11:33:29 发布

道法—自然

最新推荐文章于 2021-04-22 11:33:29 发布

阅读量1k

点赞数 1

分类专栏： jdbc

本文链接：https://blog.csdn.net/wyqwilliam/article/details/103225679

版权

本文档详细介绍了如何使用Java JDBC技术实现员工管理系统的数据库增删改查操作，包括配置文件的设置、实体类的设计、封装的数据访问对象类以及核心的业务处理方法。

摘要由CSDN通过智能技术生成

配置文件

driver=oracle.jdbc.OracleDriver
url=jdbc:oracle:thin:@localhost:1521:XE
username=scott
passwd=123456

实体类

package com.bjsxt.entity;

import java.util.Date;

public class Emp {
	public int empno;
	public String ename;
	public String job;
	public int mgr;
	public Date hiredate;
	public double sal;
	public double comm;
	public int deptno;
	public int getEmpno() {
		return empno;
	}
	public void setEmpno(int empno) {
		this.empno = empno;
	}
	public String getEname() {
		return ename;
	}
	public void setEname(String ename) {
		this.ename = ename;
	}
	public String getJob() {
		return job;
	}
	public void setJob(String job) {
		this.job = job;
	}
	public int getMgr() {
		return mgr;
	}
	public void setMgr(int mgr) {
		this.mgr = mgr;
	}
	public Date getHiredate() {
		return hiredate;
	}
	public void setHiredate(Date hiredate) {
		this.hiredate = hiredate;
	}
	public double getSal() {
		return sal;
	}
	public void setSal(double sal) {
		this.sal = sal;
	}
	public double getComm() {
		return comm;
	}
	public void setComm(double comm) {
		this.comm = comm;
	}
	public int getDeptno() {
		return deptno;
	}
	public void setDeptno(int deptno) {
		this.deptno = deptno;
	}
	@Override
	public int hashCode() {
		final int prime = 31;
		int result = 1;
		long temp;
		temp = Double.doubleToLongBits(comm);
		result = prime * result + (int) (temp ^ (temp >>> 32));
		result = prime * result + deptno;
		result = prime * result + empno;
		result = prime * result + ((ename == null) ? 0 : ename.hashCode());
		result = prime * result + ((hiredate == null) ? 0 : hiredate.hashCode());
		result = prime * result + ((job == null) ? 0 : job.hashCode());
		result = prime * result + mgr;
		temp = Double.doubleToLongBits(sal);
		result = prime * result + (int) (temp ^ (temp >>> 32));
		return result;
	}
	@Override
	public boolean equals(Object obj) {
		if (this == obj)
			return true;
		if (obj == null)
			return false;
		if (getClass() != obj.getClass())
			return false;
		Emp other = (Emp) obj;
		if (Double.doubleToLongBits(comm) != Double.doubleToLongBits(other.comm))
			return false;
		if (deptno != other.deptno)
			return false;
		if (empno != other.empno)
			ret