contranct.java

這是用javabean+jsp寫的辦公管理系統.

/*
 * contranct.java
 *Servlet+jsp+javabean实现JSP用了我一天的时间
 * Created on 2005年5月17日, 下午1:37
 */
package com.zh.util;
import javax.servlet.*;
import java.sql.*;
import java.sql.SQLException;
import javax.servlet.http.*;
import java.io.PrintStream;
import com.zh.conpool.Condata;
import java.io.*;
import com.zh.util.ClientClass;
public class contranct {
    private String text1;
    private String text2;
    private String text3;
    private String text4;
    private int text5;
    private String text6;
    private String text7;
    private String text8;
    private String modify;
    String sql;
    String sql1;
    String id;
    String cid;
    private Connection conn;
    
    ResultSet rs=null;
    /** Creates a new instance of contranct */
    public contranct() {
    }
    public void Init(HttpServletRequest req, HttpServletResponse res)
        throws ServletException,IOException, SQLException{
        PrintWriter out=res.getWriter();
        Condata con=new Condata();
        try{
            conn=con.getConnection();
        }catch(Exception e){
            e.getMessage();
        }
        text1=req.getParameter("text1");
        text2=req.getParameter("text2");
        text3=req.getParameter("text3");
        text4=req.getParameter("text4");
        try{
        	text5=Integer.parseInt(req.getParameter("text5"));
        }catch(Exception e){
        	
        }
        text6=req.getParameter("text6");
        text7=req.getParameter("text7");
        text8=req.getParameter("text8");        
        modify=req.getParameter("modify");
        id=req.getParameter("id");
        sql1 = "select * from tb_contract where ClientId='" + text1 + "'";
        rs=con.executeQuery(sql1);
        if(modify.equals("")||modify==null){
	        if(rs.next()){            
	                out.println("此合同编号已经存在");
	        }else{        		
	        	sql="insert into tb_contract(ClientId,ContractName,ClientName,ItemName,LotMoney,LotDate,EndDate,LotMan)values('"+text1+"','"+text2+"','"+text3+"','"+text4+"','"+text5+"','"+text6+"','"+text7+"','"+text8+"')";	
	        
	            int temp=con.executeUpdate(sql);
	            if(temp>0){
	                out.println("添加成功");
	            }else if(temp==0){
	                out.println("数据添加失败");
	            }else{
	                out.println("系统内部故障请与系统管理员联系");
	            }
	        }
	      }else{
       		sql="update tb_contract set ClientId='"+text1+"',ContractName='"+text2+"',ClientName='"+text3+"',ItemName='"+text4+"',LotMoney='"+text5+"',LotDate='"+text6+"',EndDate='"+text7+"',LotMan='"+text8+"' where Id='"+id+"'";
        }
        int tem=con.executeUpdate(sql);
        if(tem>0){
        	out.println("更新成功");
        }else{
        	out.println("数据库更新失败");
        }
        try{
            conn.close();
            conn=null;
        }catch(Exception e){
            e.getMessage();
        }
        try{
            con.close();
            con=null;
        }catch(Exception e){
            e.getMessage();
        }
    }    
}