/* * 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();        }    }    }