baseinfooperate.java

来自「一个完整的办公资源管理系统」· Java 代码 · 共 210 行

package org.qiming.tianke.operate;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.qiming.tianke.bean.Causeinfo;
import org.qiming.tianke.bean.Classinfo;
import org.qiming.tianke.bean.Comefile;
import org.qiming.tianke.bean.Leader;
import org.qiming.tianke.bean.Quanzong;
import org.qiming.tianke.bean.Savetime;
import org.qiming.tianke.common.DataBaseConnection;
import org.qiming.tianke.common.DisplayPage;

public class BaseinfoOperate {
	
	public BaseinfoOperate() {
		
	}
	public static List getOneClassinfoPage(String target,String cond){
		List classlist=new ArrayList();
		String columns="A.classid,A.quanzonghao,A.ziduan1,A.ziduan2,A.ziduan3";
		String tables=" classinfo A ";
		List list=DisplayPage.displayOnPage(columns, tables, "A.classid", cond, target);
		ResultSet rs=(ResultSet)list.get(4);
		try {
			while(rs.next()){
				Classinfo classinfo=new Classinfo(rs.getInt(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5));
				classlist.add(classinfo);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				rs.close();
				list.add(4,classlist);
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
		}
		
		return list;
	}
	
	
	//事由查询
	public static  List causeinfoQuery(String cond){
		DataBaseConnection conn=new DataBaseConnection();
		String sql="select causeid,causename,causedesc from cause where "+cond;
		ResultSet rs=conn.doQuery(sql);	
		System.out.println("*****"+sql+"****");
		List resultlist=new ArrayList();
		try {
			while(rs.next()){
				Causeinfo causeinfo=new Causeinfo(rs.getInt(1),rs.getString(2),rs.getString(3));
				resultlist.add(causeinfo);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			conn.doClose();
		}
		return resultlist;
	}
	//全宗号查询
	public static  List quanzonginfoQuery(String cond){
		DataBaseConnection conn=new DataBaseConnection();
		String sql="select qzhao,qzname from qzhb where "+cond;
		ResultSet rs=conn.doQuery(sql);	
		System.out.println("*****"+sql+"****");
		List resultlist=new ArrayList();
		try {
			while(rs.next()){
				Quanzong qz=new Quanzong(rs.getString(1),rs.getString(2));
				resultlist.add(qz);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			conn.doClose();
		}
		return resultlist;
	}
	//来文方式查询
	public static  List comefileMethodQuery(String cond){
		DataBaseConnection conn=new DataBaseConnection();
		String sql="select cfilename from comefile where "+cond;
		ResultSet rs=conn.doQuery(sql);	
		System.out.println("*****"+sql+"****");
		List resultlist=new ArrayList();
		try {
			while(rs.next()){
				Comefile cfile=new Comefile(rs.getString(1));
				resultlist.add(cfile);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			conn.doClose();
		}
		return resultlist;
	}
	//保存期限查询
	public static  List saveQuery(String cond){
		DataBaseConnection conn=new DataBaseConnection();
		String sql="select savename,savesource,savedate from savetime where "+cond;
		ResultSet rs=conn.doQuery(sql);	
		System.out.println("*****"+sql+"****");
		List resultlist=new ArrayList();
		try {
			while(rs.next()){
				Savetime savetime=new Savetime(rs.getString(1),rs.getString(2),rs.getString(3));
				resultlist.add(savetime);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			conn.doClose();
		}
		return resultlist;
	}
	//领导字号查询
	public static  List leaderQuery(String cond){
		DataBaseConnection conn=new DataBaseConnection();
		String sql="select leaderid,leadername,leadersdate,leaderedate from leader where "+cond;
		ResultSet rs=conn.doQuery(sql);	
		System.out.println("*****"+sql+"****");
		List resultlist=new ArrayList();
		try {
			while(rs.next()){
				Leader leader=new Leader(rs.getInt(1),rs.getString(2),rs.getString(3),rs.getString(4));
				resultlist.add(leader);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				rs.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return resultlist;
	}
	//
	public static boolean insertCause(Causeinfo causeinfo){
		boolean is=false;
		DataBaseConnection conn=new DataBaseConnection();
		String sql="insert into cause values('"+causeinfo.getCausename()+"','"+causeinfo.getCausedesc()+"')";
        is=conn.doExecute(sql);
        System.out.println("---------------"+sql);       
		return is;	
	}
	public static boolean deleteCause(int causeid){
		boolean is=false;
		DataBaseConnection conn=new DataBaseConnection();
		String sql="delete from cause where causeid="+causeid;
		is=conn.doExecute(sql);
		return is;
	}
	public static boolean updateCause(Causeinfo cause){
		boolean is=false;
		//Causeinfo cause=getOneCause(causeid);
		DataBaseConnection conn=new DataBaseConnection();
		String sql="update cause set causename='"+cause.getCausename()+"',causedesc='"+cause.getCausedesc()+"' where causeid="+cause.getCauseid();
		System.out.println("#################"+sql);
		is=conn.doExecute(sql);
		return is;
	}
	//得到主键 
//	public static int getKey(){
//		
//		String sql="select max(causeid) from  cause " ;
//        System.out.println("-------"+sql);
//        DataBaseConnection conn=new DataBaseConnection();
//		int key=Integer.parseInt(conn.getKey(sql));	
//		conn.doClose();
//		return key;
//		  
//	 }		
	public static Causeinfo getOneCause(int causeid){
		boolean is=false;
		DataBaseConnection conn=new DataBaseConnection();
		String sql="select * from cause where causeid="+causeid;
		ResultSet rs=conn.doQuery(sql);
		Causeinfo causeinfo=null;		
			try {
				while(rs.next()){				
						causeinfo=new Causeinfo(rs.getInt(1),rs.getString(2),rs.getString(3));
                }
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}finally{
				conn.doClose();
			}
		return causeinfo;
    }
}