?? contranct.java
字號:
/* * 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(); } } }
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -