contractsql.java

企业办公自动化管理系统

/*
 * ContractSql.java
 *
 * Created on 2005年5月17日, 下午7:21
 */

/**
 *
 * @author  administrator
 */
package com.zh.util;
import java.io.*;
import com.bwm.string.Str;
import javax.servlet.http.*;
import javax.servlet.*;
import java.sql.*;
import java.awt.event.*;
import java.awt.*;
import com.zh.conpool.Condata;
public class ContractSql{
    String text1;
    String text2;
    String text3;
    String text4;
    String text5;
    String text6;
    String text7;
    String text8;
    Condata con=new Condata();
    Str str=new Str();
    Connection conn=null;
    ResultSet rs=null;
    String sql;
    String sql1;
    String contrantname;
    /** Creates a new instance of ContractSql */
    public ContractSql() {
    }
    public String RsSql(String contrantname){
        this.contrantname=contrantname;
        if(contrantname==null){
            sql="select * from tb_contract";
        }else{
            sql="select * from tb_contract where ClientId='"+contrantname+"'";
        }
        return sql;
    }
    public String ContSql(){
        sql1="select * from tb_contract";
        return sql1;
    }
    public ResultSet ConSql(){
        try{
            con.getConnection();
        }catch(Exception e){
            e.getMessage();
        }
       
        rs=con.executeQuery(RsSql(contrantname));
        try{
            conn.close();
            conn=null;
        }catch(Exception e){
            e.getMessage();
        }
        try{
            con.close();
            con=null;
        }catch(Exception e){
            e.getMessage();
        }
        return rs;
    }
     public void Init(HttpServletRequest req, HttpServletResponse res)
        throws ServletException,IOException, SQLException{
        PrintWriter out=res.getWriter();
        try{
            con.getConnection();
        }catch(Exception e){
            e.getMessage();
        }
        while(ConSql().next()){
            String t1=ConSql().getString(2);
            String t2=ConSql().getString(3);
            out.println(t1);
            out.println(t2);
        }
     }
}