📄 samupdata.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<HTML>
<BODY bgcolor=white><Font size=3>
<p>
<%!//处理字符串的一个常用方法：
int a[]=new int[3];
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 i=0;
boolean g=true;
String s=null;
double result=0;
int a[]=new int[3];
String answer=null;
int flag=1;
s=request.getParameter("time");
int timelen=s.length();
int timesign=1;
if(timelen==0)
{
s="空";
timesign=0;
}
else
{
if(s!=null)
{ StringTokenizer fenxi=new StringTokenizer(s,"-");
while(fenxi.hasMoreTokens())
{
String temp=fenxi.nextToken();
try{ a[i]=Integer.valueOf(temp).intValue();
i++;
}
catch(NumberFormatException e)
{
out.print("日期格式错误，2秒后返回重新操作");
out.print("<META HTTP-EQUIV=REFRESH CONTENT=2;url=samedit.jsp>");
flag=0;
}
}
if(a[0]<2000||a[0]>3000||a[1]>12||a[1]<1||a[2]>30||a[2]<1)
{
out.print("日期格式错误，2秒后返回重新操作");
out.print("<META HTTP-EQUIV=REFRESH CONTENT=2;url=samedit.jsp>");
flag=0;
}
}
}
String newsno=request.getParameter("sno");
if(newsno==null)
{newsno="";
}
byte h[]=newsno.getBytes("ISO-8859-1");
newsno=new String(h);
String newpcode=request.getParameter("pcode");
if(newpcode==null)
{newpcode="";
}
byte c[]=newpcode.getBytes("ISO-8859-1");
newpcode=new String(c);
String newcno=request.getParameter("cno");
if(newcno==null)
{newcno="";
}
byte b[]=newcno.getBytes("ISO-8859-1");
newcno=new String(b);
int cnosign=1;
int pcodesign=1;
int cnolen=newcno.length();
if(cnolen==0)
{
newcno="空";
cnosign=0;
}
int pcodelen=newpcode.length();
if(pcodelen==0)
{
newpcode="空";
pcodesign=0;
}
%>
<%
if(flag==1)
{
Connection con1=null;
Statement sql1=null;
ResultSet rs1=null;
ResultSet rs2=null;
int flag1=1;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try { con1=DriverManager.getConnection("jdbc:odbc:mis");
sql1=con1.createStatement();
String condition="SELECT * FROM psample WHERE sampleno = '"+newsno+"'";
rs1=sql1.executeQuery(condition);
if(!rs1.next())
{
out.print("该试样不存在，2秒后返回重新操作");
out.print("<META HTTP-EQUIV=REFRESH CONTENT=2;url=samedit.jsp>");
flag1=0;
}
else
{
if(cnosign==0)
{
newcno=rs1.getString(6);
}
if(timesign==0)
{
s=rs1.getString(4);
}
if(pcodesign==0)
{
newpcode=rs1.getString(5);
}
}
con1.close();
}
catch(SQLException e1) {}
%>
<%
if(flag1==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 condition1=
"UPDATE psample SET rdate ='"+s+"' WHERE sampleno = '"+newsno+"'",
condition2=
"UPDATE psample SET pcode ='"+newpcode+"' WHERE sampleno = '"+newsno+"'",
condition3=
"UPDATE psample SET colorno ='"+newcno+"' WHERE sampleno = '"+newsno+"'";
//执行更新操作：
sql.executeUpdate(condition1);
sql.executeUpdate(condition2);
sql.executeUpdate(condition3);
out.print("编辑试样资料完成，2秒后返回试样页面");
out.print("<META HTTP-EQUIV=REFRESH CONTENT=2;url=psample.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 + -