表结构:
1 ID numeric 9 0
0 sheng nvarchar 150 1
0 shi nvarchar 150 1
0 qu nvarchar 50 1
0 name nvarchar 150 1
0 khlb nvarchar 100 1
0 lbm nvarchar 50 1
0 khbm nvarchar 50 1
0 dwxz nvarchar 100 1
0 add1 nvarchar 150 1
0 youbian nvarchar 50 1
0 lxr nvarchar 50 1
0 lxrzw nvarchar 50 1
0 tel nvarchar 100 1
0 fax nvarchar 100 1
0 modid nvarchar 100 1
0 yx ntext 16 1
0 atime datetime 8 0
0 w_men nvarchar 50 1
1 ID numeric 9 0
0 sheng nvarchar 150 1
0 shi nvarchar 150 1
0 qu nvarchar 50 1
0 name nvarchar 150 1
0 khlb nvarchar 100 1
0 lbm nvarchar 50 1
0 khbm nvarchar 50 1
0 dwxz nvarchar 100 1
0 add1 nvarchar 150 1
0 youbian nvarchar 50 1
0 lxr nvarchar 50 1
0 lxrzw nvarchar 50 1
0 tel nvarchar 100 1
0 fax nvarchar 100 1
0 modid nvarchar 100 1
0 yx ntext 16 1
0 atime datetime 8 0
0 w_men nvarchar 50 1
解决方案 »
- eclipse上启动的tomcat无法热部署?
- Hibernate ID生成问题
- struts+daojboss报错!!!!急
- servlet如何把处理完的数据返回给jsp页?
- 一个数据库连接的问题,大虾们帮我看看,谢谢
- 基于b/s结构的电子白板的实现?
- 有没有人用jsp开发过项目发布到网站虚拟空间上啊?
- 很简单的问题,tomcat 的server.xml的配置,教教我!
- 请高手帮忙!!どうも ありがとう(谢谢)!
- 为什么这几天上不了“www.cnjsp.com”网站上不是他们的IP地址解析出现错误
- java里ascll码的转换函数是什么,也就是相当于vb里的chr函数
- 如何实现点击图标,播放MP3或其它多媒体
<%@ page import="java.lang.*"%>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%@ page contentType="text/html;charset=gb2312"%>
<%@ include file="database/conn.jsp"%>
<%! String sql,sheng,shi,qu,name,khlb,dwxz,add,youbian,lxr,lxrzw,tel,fax,modid1,lbm,yx,t3;int t1, t2;%>
<html>
<head>
<meta name="GENERATOR" Content="Microsoft FrontPage 4.0"><style TYPE="text/css">.content1 {color: #0080C0; }
.content3 {color: #FFFFFF; }
.content4 {color: #71AFAF; }
H1 {color: black; background: #ffeeee; }
H2 {color: black; background: #eeffee; }
A {text-decoration:none;color:"#666666"}
a:hover {color:"#666666";text-decoration:underline}
</style>
</head>
<body><%try{
sheng=request.getParameter("sheng");
if (sheng!=null)
sheng=new String(sheng.getBytes("8859_1"));
shi=request.getParameter("shi");
if (shi!=null)
shi=new String(shi.getBytes("8859_1"));
qu=request.getParameter("qu");
if (qu!=null)
qu=new String(qu.getBytes("8859_1"));
name=request.getParameter("name1");
if (name!=null)
name=new String(name.getBytes("8859_1"));
khlb=request.getParameter("lb");
if (khlb!=null)
khlb=new String(khlb.getBytes("8859_1"));
dwxz=request.getParameter("dwxz");
if (dwxz!=null)
dwxz=new String(dwxz.getBytes("8859_1"));
add=request.getParameter("dz");
if (add!=null)
add=new String(add.getBytes("8859_1"));
youbian=request.getParameter("yb");
if (youbian!=null)
youbian=new String(youbian.getBytes("8859_1"));
lxr=request.getParameter("lxr");
if (lxr!=null)
lxr=new String(lxr.getBytes("8859_1"));
lxrzw=request.getParameter("lxrzw");
if (lxrzw!=null)
lxrzw=new String(lxrzw.getBytes("8859_1"));
tel=request.getParameter("dh");
if (tel!=null)
tel=new String(tel.getBytes("8859_1"));
fax=request.getParameter("cz");
if (fax!=null)
fax=new String(fax.getBytes("8859_1"));
modid1=request.getParameter("yddh");
if (modid1!=null)
modid1=new String(modid1.getBytes("8859_1"));
yx=request.getParameter("khyj");
if (yx!=null)
yx=new String(yx.getBytes("8859_1"));//生成类别码
try{
String sql;
ResultSet rs;
sql = "select lbm from khlb where khlb='"+khlb+"'";
rs = conn.executeQuery(sql);
rs.next();
lbm=rs.getString("lbm");
rs.close();
}catch(Exception a)
{
out.println(a.toString());
}
%>
<%
//生成客户编码
try{
sql="select max(khbm) as tt from khb where khlb='"+khlb+"'";
ResultSet rs1 = conn.executeQuery(sql);
rs1.next();
out.println(rs1.getString(1));
//out.println(rs1.getString("tt"));
t1=Intterger.parseInt(rs1.getString("tt"));
t1=t1+1;
t2=t1-(t1%10);
if (t2==0)
t3="0000"+(char)t1;
if (t2>0 & t2<10)
t3="000"+(char)t1;
if (t2>=10 & t2<100)
t3="00"+(char)t1;
if (t2>=100 & t2<1000)
t3="00"+(char)t1;
rs1.close();
}catch(Exception w)
{
out.println(w.toString());
}
%>
<%
conn.close(); PreparedStatement stm=con.prepareStatement("insert into khb (sheng,shi,qu,name,khlb,dwxz,add1,youbian,lxr,lxrzw,tel,fax,modid,yx,lbm,khbm) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
stm.setString(1,sheng);
stm.setString(2,shi);
stm.setString(3,qu);
stm.setString(4,name);
stm.setString(5,khlb);
stm.setString(6,dwxz);
stm.setString(7,add);
stm.setString(8,youbian);
stm.setString(9,lxr);
stm.setString(10,lxrzw);
stm.setString(11,tel);
stm.setString(12,fax);
stm.setString(15,lbm);
stm.setString(13,modid1);
stm.setString(14,yx);
stm.setString(16,t3);
try{
stm.executeQuery();
}catch(Exception e)
{
//out.println(e.toString());
}
stm.close();
conn.close();
con.close(); }catch(Exception d)
{
out.println(d.toString());
}out.println("ok");
%>
</body>
</html>