clientsql.java

JSP简单的OA系统_非常不错的一个系统

package com.zh.util;
import java.sql.*;
import com.zh.conpool.*;
import com.bwm.string.*;
public class ClientSql{
	private String sql=null;
	ResultSet rs=null;
	Condata con=new Condata();
	Str str=new Str();
	Connection conn=null;
	String id;
	String sql1;
	boolean fal=false;
	public String getSql(String clientname){
		if(clientname==null){
			sql="select * from tb_client";
		}else{
			sql="select * from tb_client where ClientName='"+str.toChinese(clientname)+"'";
		}
		return sql;
	}
        public String getClient(){
            sql="select * from tb_client";
            return sql;
        }
	public String getId(String id){
		this.id=id;
		sql="select * from tb_client where Id='"+id+"'";
		return sql;
	}
        public String getPerson(){
            sql="select * from tb_person";
            return sql;
        }
	public ResultSet Rs(String sql){
		try{
			con.getConnection();
		}catch(Exception e){
			e.getMessage();
		}
		rs=con.executeQuery(getId(id));
		return rs;
	}
	public boolean Id_class(){
		boolean fag=false;
		try{
			con.getConnection();
		}catch(Exception e){
			e.getMessage();
		}
		rs=con.executeQuery(getId(id));
		if(rs!=null){
			 fag=true;
		}else{
			fag=false;
		}
		return fag;
	}
	public boolean del_class(){
        try{
        	con.getConnection();
        }catch(Exception e){
        	e.getMessage();
        }
        boolean bol=false;
		int temp=con.executeUpdate(Del(id));
		if(temp>0){
			bol=true;
		}else{
            bol=false;
		}
		con.close();
		con=null;
		return bol;
		
	}
	public String Del(String id){
		this.id=id;
		sql1="delete from tb_client where Id='"+id+"'";	
		return sql1;
	}
	public boolean execute()throws Exception{
		boolean flag=false;
		try{
			con.getConnection();
		}catch(Exception e){
			e.getMessage();
		}
		rs=con.executeQuery(getSql(null));
		if(rs!=null){
			flag=true;
		}else{
			flag=false;
		}
		conn.close();
		rs.close();
		con.close();
		return flag;
	}
	public static void main(String[] para){
		ResultSet rs=null;
		ClientSql c1=new ClientSql();
		try{
			rs=c1.Rs();
		}catch(Exception e){
				
		}
		System.out.println(rs);
	}

    }