超市管理系统源代码

第1章JavaBean部分
1.1 数据库连接（DataBase.java）
package common;
import java.sql.*;
import javax.naming.*;
import javax.sql.*;
import java.util.*;
public class DataBase {
private String dbUrl =
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ManagermentDB";
private String dbUser = "ren";
private String dbPwd = "ren";//定义数据库的连接
public DataBase() throws Exception{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}//加载数据库的驱动
public Connection getConnection()throws Exception{
return java.sql.DriverManager.getConnection(dbUrl,dbUser,dbPwd);
}//建立数据库的连接
public void closeConnection(Connection con){
try{
if(con!=null) con.close();
}catch(Exception e){
e.printStackTrace();
}
}
public void closePrepStmt(PreparedStatement prepStmt){
try{
if(prepStmt!=null) prepStmt.close();
}catch(Exception e){
e.printStackTrace();
}
}
public void closeResultSet(ResultSet rs){//关闭当前记录集
try{
if(rs!=null) rs.close();
}catch(Exception e){
e.printStackTrace();
}
}
public static void close( ResultSet rs, Statement st, Connection conn )//关闭数据库的连接
{
try
{
if( rs!=null ) rs.close();
}
catch( SQLException ex ) { };
try
{
if( st!=null ) st.close();
}
catch( SQLException ex ) { };
try
{
if( conn!=null ) conn.close(); }
catch( SQLException ex ) { };
}
}
1.2 人事管理部门
1.2.1员工实体的定义（Employees.java）
package employees;
public class Employees implements Comparable{
private String EmpId;
private String DepId;
private String EmpName;
private String Sex;
private String Nationality;
private String Birth;
private String Academic;
private String Marital;
private String Original;
private String Id_Card;
private String Mobile;
private String Memo;
//员工实体的属性
Employees(String EmpId,String DepId,String EmpName ,String Sex,
String Nationality,String Birth,String Academic,String Marital,
String Original,String Id_Card,String Mobile,String
Memo){ //初始化操作
this.EmpId = EmpId;
this.DepId = DepId;
this.EmpName = EmpName;
this.Sex = Sex;
this.Nationality = Nationality;
this.Birth = Birth;
this.Academic = Academic ;
this.Marital = Marital;
this.Original = Original;
this.Id_Card = Id_Card;
this.Mobile = Mobile ;
this.Memo = Memo;
}
//对每一个属性赋值和取值操作
public void setEmpId(String newEmpId){
this.EmpId = newEmpId;
}
public String getEmpId(){
return EmpId;
}
public void setDepId(String newDepId){
this.DepId = newDepId;
}
public String getDepId(){
return DepId;
}
public void setEmpName(String newEmpName){ this.EmpName = newEmpName;
}
public String getEmpName(){
return EmpName;
}
public void setSex(String newSex){
this.Sex = newSex;
}
public String getSex(){
return Sex;
}
public void setNationality(String newNationality){ this.Nationality = newNationality;
}
public String getNationality(){
return Nationality;
}
public void setBirth(String newBirth){
this.Birth = newBirth;
}
public String getBirth(){
return Birth;
}
public void setAcademic(String newAcademic){ this.Academic = newAcademic;
}
public String getAcademic(){
return Academic;
}
public void setMarital(String newMarital){
this.Marital = newMarital;
}
public String getMarital(){
return Marital;
}
public void setOriginal(String newOriginal){
this.Original = newOriginal;
}
public String getOriginal(){
return Original;
}
public void setId_Card(String newId_Card){
this.Id_Card = newId_Card;
}
public String getId_Card(){
return Id_Card;
}
public void setMobile(String newMobile){
this.Mobile = newMobile;
}
public String getMobile(){
return Mobile;
}
public void setMemo(String newMemo){
this.Memo = newMemo;
}
public String getMemo(){
return Memo;
}
public int compareTo(Object o){
Employees n = (Employees)o;
int lastCmp = pareTo(n.EmpName);
return(lastCmp);
}
}
1.2.2员工实体的操作（EmployeesBean.java）
package employees;
import java.sql.*;
import java.util.*;
import javax.naming.*;
import javax.sql.*;。