【Java开源代码栏目提醒】:网学会员为需要Java开源代码的朋友们搜集整理了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();
}
}
}
上一篇:
ContractVariation.java
下一篇:
还记得,那年的风车吗?