一、思路
1.创建数据库(岗位表)
2.创建实体类(要继承Serializable,Comparable两个类)
2.创建控制层(Servlet)–>工具层(Service)—>数据库连接层(Dao)
3.使用junit进行测试
4.测试结果无误后,修改视图层
二、数据库创建
create table station (
stationno int(10) not null auto_increment,
stationname varchar(100) not null,
remark varchar(100) ,
PRIMARY key(stationno)
)
select * from station
INSERT into station values(DEFAULT,'总裁','公司总体发展战略规划和管理')
INSERT into station values(DEFAULT,'教学经理','负责日常教学管理')
INSERT into station values(DEFAULT,'咨询经理','完成咨询部日常管理')
INSERT into station values(DEFAULT,'咨询师','完成日常咨询任务')
三、实体类创建
package com.facai.entity;
import java.io.Serializable;
public class Station implements Serializable,Comparable{
private int stationno;
private String stationname;
private String remark;
public int getStationno() {
return stationno;
}
public void setStationno(int stationno) {
this.stationno = stationno;
}
public String getStationname() {
return stationname;
}
public void setStationname(String stationname) {
this.stationname = stationname;
}
public String getRemark() {
return remark;
}
public void setRemark(String remark) {
this.remark = remark;
}
@Override
public String toString() {
return "Station [stationno=" + stationno + ", stationname="
+ stationname + ", remark=" + remark + "]";
}
public Station(int stationno, String stationname, String remark) {
super();
this.stationno = stationno;
this.stationname = stationname;
this.remark = remark;
}
public Station() {
super();
}
@Override
public int hashCode() {
final int prime = 31;
int result = 1;
result = prime * result + ((remark == null) ? 0 : remark.hashCode());
result = prime * result
+ ((stationname == null) ? 0 : stationname.hashCode());
result = prime * result + stationno;
return result;
}
@Override
public boolean equals(Object obj) {
if (this == obj)
return true;
if (obj == null)
return false;
if (getClass() != obj.getClass())
return false;
Station other = (Station) obj;
if (remark == null) {
if (other.remark != null)
return false;
} else if (!remark.equals(other.remark))
return false;
if (stationname == null) {
if (other.stationname != null)
return false;
} else if (!stationname.equals(other.stationname))
return false;
if (stationno != other.stationno)
return false;
return true;
}
@Override
public int compareTo(Object o) {
// TODO Auto-generated method stub
return 0;
}
}
</