query.java

一个日程管理和通讯录管理的软件,采用的Access数据库,其中用到了三个自已写的三个控件:无售点按钮(NFButton.ocx)、带图片的按钮(ImageButton.ocx)、改进的日历控件(Gol

 package myBeans;
import java.sql.*;

public class Query {
	String Eno,name,sex,age,Department,email,phone,EnrollmentDate,monthWorkLoad,yearWorkLoad;
	String message;
	Connection con;
	Statement sql;
	ResultSet rs;
	public Query(){
		//加载桥接器
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}catch(ClassNotFoundException e){}
	}
	//设置属性值、获取属性值的方法
	public String getAge() {
		return age;
	}
	public void setAge(String age) {
		this.age = age;
	}
	public String getDepartment() {
		return Department;
	}
	public void setDepartment(String department) {
		Department = department;
	}
	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
	public String getEno() {
		return Eno;
	}
	public void setEno(String eno) {
		Eno = eno;
	}
	public String getEnrollmentDate() {
		return EnrollmentDate;
	}
	public void setEnrollmentDate(String enrollmentDate) {
		EnrollmentDate = enrollmentDate;
	}
	public String getMonthWorkLoad() {
		return monthWorkLoad;
	}
	public void setMonthWorkLoad(String monthWorkLoad) {
		this.monthWorkLoad = monthWorkLoad;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getPhone() {
		return phone;
	}
	public void setPhone(String phone) {
		this.phone = phone;
	}
	public String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}
	public String getYearWorkLoad() {
		return yearWorkLoad;
	}
	public void setYearWorkLoad(String yearWorkLoad) {
		this.yearWorkLoad = yearWorkLoad;
	}
	
	//查询员工信息
	public String getMessage(){
		try{
			con=DriverManager.getConnection("jdbc:odbc:bysj","","");
			sql=con.createStatement();
			String condition="SELECT * FROM employees";
			System.out.println(condition);
			rs=sql.executeQuery(condition);
			int rowcount=0;
			while(rs.next()){
				rowcount++;
				System.out.print("员 工 号 "+rs.getString("Eno"));
				System.out.print("姓    名 "+rs.getString("name"));
				System.out.print("性    别 "+rs.getString("sex"));
				System.out.print("出生年月 "+rs.getDate("age"));
				System.out.print("部门名称 "+rs.getString("Department"));
				System.out.print("电子邮箱 "+rs.getString("email"));
				System.out.print("电    话 "+rs.getString("phone"));
				System.out.print("上岗时间 "+rs.getString("EnrollmentDate"));
				System.out.print("月工作量 "+rs.getString("monthWorkLoad"));
				System.out.println("年工作量 "+rs.getString("yearWorkLoad"));
			}
			if (rowcount!=0){
				 message="ok";
			}else{
				System.out.println("目前没有记录");
				 message="empty";
			}
			con.close();
			return message;
		}catch(SQLException e){
			message="empty";
			return message;
		}
	}
}