loginmodel.java

这是我在北大青鸟accp4.0 第一学期 的java 项目<员工管理系统>,采用db,model,view,三层关系. 连接数据库驱动为jdbc 用eclipse完成的手写的窗体代码,

package com.accp.model;
import java.sql.*;

import javax.swing.JOptionPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;
import javax.swing.tree.DefaultTreeModel;
import javax.swing.tree.DefaultMutableTreeNode;
import com.accp.db.DBManager;

/**
 * 登录模型
 * @author Administrator
 *
 */
public class LoginModel {
	
	private ResultSet rs=null;
	DBManager db;
	
	//验证库中是否有此用户名.得到true或false
	public boolean login(String name,String pwd) {
		 db=new DBManager();
	     String sql = "select * from OPERATOR where name='"+name+"'"+" and pwd="+"'"+pwd+"'";      
	     
	     rs = db.getRs(sql);
	     boolean flag = false;
	     try {
	       flag = rs.next();
	       rs.close();
	     }
	     catch (SQLException ex) {
	       ex.printStackTrace();
	     }
	     return flag;
	   }
	//修改密码,成功返回true
	public boolean update(String name,String pwd){
		String sql = "update OPERATOR set pwd='"+pwd+"' where name='"+name+"'";      
		  db=new DBManager();
		  int i=db.exeSql(sql);
		  
		  return (i>0);
		  }
	//查询empno 返回rs结果
	public ResultSet queryborrowuser() {
		 db=new DBManager();
	     String sql = "select empno from EMPLOYEE";   
	     
	     rs = db.getRs(sql);
	     return rs;
	   }
	//增加职工
	public boolean employeemanager_insert(String empno,String ename,String position,String remarks) {
		 db=new DBManager();

		  int i=db.exeSql("insert into EMPLOYEE values('"+empno+"','"+ename+"','"+position+"','"+remarks+"')");
		  return (i>0);
		  }
	//删除职工
	public boolean employeemanager_del(String empno) {
		 db=new DBManager();

		  int i=db.exeSql("delete from employee where empno='"+empno+"'");
		  return (i>0);
		  }
	//查询职工
	public void employeemanager_query(String sql) {
		 db=new DBManager();
		 int i=1;
		 new JTable(db.getTableModel(sql));
	    

		  }
	//更新职工
	public boolean employeemanager_update(String empno,String ename,String position,String remarks) {
		 db=new DBManager();

		  int i=db.exeSql("update employee set ename='"+ename+"',position='"+position+"',remarks='"+remarks+"' where empno='"+empno+"'");
		  return (i>0);
		  }
	//资产类别增加
	public boolean category_manager_insert(String cateid,String catename,String subcateid,String subcatename) {
		 db=new DBManager();
		 int i=db.exeSql("insert into CATEGORY values('"+cateid+"','"+catename+"','"+subcateid+"','"+subcatename+"')");
		  return (i>0);
		  }
	//资产类别删除
	public boolean category_manager_del(String cateid,String subcateid) {
		 db=new DBManager();
		 int i=db.exeSql("delete from CATEGORY where cateid='"+cateid+"' and subcateid='"+subcateid+"'");
		  return (i>0);
		  }
	//资产类别修改
	public boolean category_manager_update(String cateid,String catename,String subcateid,String subcatename) {
		 db=new DBManager();
		  int i=db.exeSql("update CATEGORY set catename='"+catename+"',subcatename='"+subcatename+"' where cateid='"+cateid+"' and subcateid='"+subcateid+"'");
		  return (i>0);
		  }
//	资产类别查询
	public void category_manager_query(String sql) {
		 db=new DBManager();
		 int i=1;
		 new JTable(db.getTableModel(sql));
		  }

//固定资产增加
	public boolean asset_insert(String assetid,String asset_name,String cateid,String subcateid,String model,String price,String purchase_date,String status,String useby,String remark) {
		 db=new DBManager();
		 int i=db.exeSql("insert into Asset values('"+assetid+"','"+asset_name+"','"+cateid+"','"+subcateid+"','"+model+"','"+price+"','"+purchase_date+"','"+status+"','"+useby+"','"+remark+"')");
		  return (i>0);
		  }	
//固定资产删除
	public boolean asset_del(String assetid) {
		 db=new DBManager();
		 int i=db.exeSql("delete from ASSET where assetid='"+assetid+"'");
		  return (i>0);
		  }
//固定资产修改
	public boolean asset_update(String assetid,String asset_name,String cateid,String subcateid,String model,String price,String purchase_date,String status,String useby,String remark) {
		 db=new DBManager();
		  int i=db.exeSql("update ASSET set asset_name='"+asset_name+"',cateid='"+cateid+"',subcateid='"+subcateid+"',model='"+model+"',price='"+price+"',purchase_date='"+purchase_date+"',status='"+status+"',useby='"+useby+"' where assetid='"+assetid+"'");
		  return (i>0);
		  }
	
//借用
	public int lendborrow_insert(String assetid,String empno,String usedate,String retdate,String isreturn,String lender,String remarks) {
		 db=new DBManager();
		 rs=db.getRs("select status from ASSET where assetid='"+assetid+"'");
			try
			{
				 while(rs.next()){
					
					 return Integer.parseInt(rs.getString(1));
				 }
			}catch(SQLException e){}
			
	return db.exeSql("insert into LEND values('"+assetid+"','"+empno+"','"+usedate+"','"+retdate+"','"+isreturn+"','"+lender+"','"+remarks+"')");
		 //int i=db.exeSql("insert into LEND values('2','002','2007-11-1','','1','001','123')");
		 
}

//归还
	public boolean lendborrow_giveback(String assetid,String empno,String usedate,String retdate,String isreturn,String lender,String remarks) {
		 db=new DBManager();
		//  int i=db.exeSql("update into LEND values('"+assetid+"','"+empno+"','"+usedate+"','"+retdate+"','"+isreturn+"','"+lender+"','"+remarks+"')");
		  int i=db.exeSql("update LEND set empno='"+empno+"',retdate='"+retdate+"',isreturn='"+isreturn+"',remarks='"+remarks+"' where assetid='"+assetid+"'");
		  //int i=db.exeSql("insert into LEND values('2','002','2007-11-1','','1','001','123')");
		  return (i>0);
		}
//	查询sql 返回rs结果
	public ResultSet querysql(String sql) {
		 db=new DBManager();
	     //String sql = "select empno from EMPLOYEE";   
	     
	     rs = db.getRs(sql);
	     return rs;
	   }
	
}