📄 newdata.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<HTML>
<BODY bgcolor=white ><Font size=3>
<p>
<%!//处理字符串的一个常用方法：
int t[]=new int[2];
int d[]=new int[2];
String answer=null;
String state="0";
public String getString(String s)
{ if(s==null) s="";
try {byte a[]=s.getBytes("ISO-8859-1");
s=new String(a);
}
catch(Exception e)
{ }
return s;
}
%>
<% String s1=response.encodeRedirectURL("check.jsp");
String s2=response.encodeRedirectURL("admin.jsp");
%>
<% //为了防止客户直接进入该页面，首先从session对象获取密码和帐号信息：
String name="",password="";
if(session.isNew())
{//如果直接进入该页面就再连接到登录页面：
response.sendRedirect("admin.jsp");
}
else
{ name=(String)session.getAttribute("name");
password=(String)session.getAttribute("password");
password=getString(password);
name=getString(name);
}
Connection con4=null;
Statement sql4=null;
ResultSet rs4=null;
boolean boo=false;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException event){}
try { con4=DriverManager.getConnection("jdbc:odbc:mis");
sql4=con4.createStatement();
String condition9="SELECT * FROM admin WHERE adminname = "+"'"+name+"'";
rs4 =sql4.executeQuery(condition9);
while(rs4.next())
{ String n=rs4.getString("adminname");
String s=rs4.getString("adminpwd");
if(name.equals(n)&&password.equals(s))
{boo=true; break;
}
}
con4.close();
}
catch(SQLException e1) {}
%>
<%
if(boo)
{
int flag=1;
int lownumber=0;
int lastnumber=0;
int firstnumber=0;
int secondnumber=0;
int countnumber=0;
boolean bool=true;
boolean boole=true;
String newname=request.getParameter("na");
if(newname==null)
{
newname="";
}
byte g[]=newname.getBytes("ISO-8859-1");
newname=new String(g);
String newpwd=request.getParameter("password");
if(newpwd==null)
{newpwd="12345";
}
byte a[]=newpwd.getBytes("ISO-8859-1");
newpwd=new String(a);
String newaddre=request.getParameter("addre");
if(newaddre==null)
{newaddre="空";
}
byte b[]=newaddre.getBytes("ISO-8859-1");
newaddre=new String(b);
String newnote=request.getParameter("note");
if(newnote==null)
{newnote="空";
}
byte f[]=newnote.getBytes("ISO-8859-1");
newnote=new String(f);
int addrelen=newaddre.length();
if(addrelen==0)
{
newaddre="空";
}
int namelen=newname.length();
if(namelen==0)
{
flag=0;
out.print("姓名不可以为空，2秒后返回重新操作");
out.print("<META HTTP-EQUIV=REFRESH CONTENT=2;url=new.jsp>");
}
int pwdlen=newpwd.length();
if(pwdlen==0)
{
newpwd="空";
}
int notelen=newnote.length();
if(notelen==0)
{
newnote="空";
}
int i=0;
double result=0;
String newtel=null;
newtel=request.getParameter("tel");
int tellen=newtel.length();
int telsign=1;
if(tellen==0)
{
newtel="空";
telsign=0;
}
if(telsign==1)
{
i=0;
int t[]=new int[2];
String answer=null;
if(newtel!=null)
{ StringTokenizer fenxi=new StringTokenizer(newtel,"-");
while(fenxi.hasMoreTokens())
{
String temp1=fenxi.nextToken();
try{ t[i]=Integer.valueOf(temp1).intValue();
i++;
}
catch(NumberFormatException et)
{
out.print("电话号码格式错误，2秒后返回重新操作");
out.print("<META HTTP-EQUIV=REFRESH CONTENT=2;url=new.jsp>");
flag=0;
}
}
}
if(t[0]<0||t[0]>9999||t[1]<=0)
{ flag=0;
out.print("电话号码格式错误，2秒后返回重新操作");
out.print("<META HTTP-EQUIV=REFRESH CONTENT=2;url=new.jsp>");
}
}
String newfax=null;
newfax=request.getParameter("fax");
int faxlen=newfax.length();
int faxsign=1;
if(faxlen==0)
{
newfax="空";
faxsign=0;
}
if(faxsign==1)
{
i=0;
result=0;
int d[]=new int[2];
answer=null;
if(newfax!=null)
{ StringTokenizer fenxid=new StringTokenizer(newfax,"-");
while(fenxid.hasMoreTokens())
{
String tempd=fenxid.nextToken();
try{ d[i]=Integer.valueOf(tempd).intValue();
i++;
}
catch(NumberFormatException ed)
{
out.print("传真号码格式错误，2秒后返回重新操作");
out.print("<META HTTP-EQUIV=REFRESH CONTENT=2;url=new.jsp>");
flag=0;
}
}
}
if(d[0]<0||d[0]>9999||d[1]<=0)
{ flag=0;
out.print("传真号码格式错误，2秒后返回重新操作");
out.print("<META HTTP-EQUIV=REFRESH CONTENT=2;url=new.jsp>");
}
}
String newemail=request.getParameter("email");
int emaillen=newemail.length();
int emailsign=1;
if(emaillen==0)
{
newemail="空";
emailsign=0;
}
if(emailsign==1)
{
int fp1=0,fp2=0;
fp1=newemail.indexOf('@',1);
fp2=newemail.indexOf('.',fp1+1);
int lenth=0;
lenth=newemail.length();
if(fp1<0||fp1>=lenth||fp2<0||fp2>=lenth||fp2==(fp1+1))
{
flag=0;
out.print("E-Mail格式错误，2秒后返回重新操作");
out.print("<META HTTP-EQUIV=REFRESH CONTENT=2;url=new.jsp>");
}
}
%>
<%
Connection con1=null;
Statement sql1=null;
ResultSet rs1=null;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e3){}
try { con1=DriverManager.getConnection("jdbc:odbc:mis");
sql1=con1.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
String condition="SELECT custid FROM customer";
rs1=sql1.executeQuery(condition);
rs1.last();
countnumber=rs1.getRow();
lastnumber=rs1.getInt("custid");
rs1.first();
firstnumber=rs1.getInt("custid");
if(firstnumber!=0)
{
boole=false;
}
if(boole)
{
if((lastnumber-firstnumber+1)==countnumber)
{
bool=false;
}
if(bool)
{
while(rs1.next())
{
secondnumber=rs1.getInt("custid");
if((secondnumber-firstnumber)==1)
{
firstnumber=secondnumber;
}
else
{ lownumber=firstnumber+1;}
}
}
else
{
lownumber=countnumber+firstnumber;
}
}
else
{
lownumber=0;
}
con1.close();
}
catch(SQLException e1) {}
%>
<%
if(flag==1)
{
Connection con=null;
Statement sql=null;
ResultSet rs=null;
boolean isEqual;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e2){}
try {
con=DriverManager.getConnection("jdbc:odbc:mis");
sql=con.createStatement();
String condition=
"INSERT INTO customer VALUES "+"("+lownumber+",'"+newname+"','"+newaddre+"','"+newtel+"','"+newfax+"','"+newemail+"','"+newnote+"','"+newpwd+"')";
sql.executeUpdate(condition);
out.print("新增客户资料完成，2秒后返回管理页面");
out.print("<META HTTP-EQUIV=REFRESH CONTENT=2;url=check.jsp>");
con.close();
}
catch(SQLException e1)
{ }
}
}
else
{
out.print("请先登陆，系统将于2秒钟后自动返回登陆页面");
out.print("<META HTTP-EQUIV=REFRESH CONTENT=2;url=admin.jsp>");
}
%>
</FONT>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -