📄 modify1.jsp
字号:
<%@page session="true"%>
<%@ page contentType="text/html;charset=gb2312" %>
<HTML>
<HEAD>
<TITLE>modify</TITLE>
</HEAD>
<BODY>
<%@ page language="java" import="java.sql.*,javax.sql.*;" %>
修改信息窗口
[<a href="modify.html" target=3>返回</a>]
<%
String name=(String)session.getAttribute("user");
String sort=(String)session.getAttribute("sort");
String production=request.getParameter("production");
session.setAttribute("production",production);
//out.println("<hr>"+name+"<br>"+sort+"<br>"+production+"<hr>");
String jdbcDriver="com.mysql.jdbc.Driver";
String jdbcURL="jdbc:mysql://localhost:3306/teacher";
try{
Class.forName(jdbcDriver);
Connection con=DriverManager.getConnection(jdbcURL,"root","000000");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from "+sort+" where author='"+name+"' and production='"+production+"'");
if (sort.equals("getAward") && rs.next()){
String author=new String(rs.getString("author").toString().getBytes("8859_1"));
production=new String(production.toString().getBytes("8859_1"));
String band=new String(rs.getString("awardBand").toString().getBytes("8859_1"));
String time=rs.getString("time");
String number=rs.getString("number");
%>
<FORM action="modify2.jsp" method="GET">
请修改获奖信息<br><br>
作者姓名：<INPUT TYPE="TEXT" NAME="author" VALUE=<%=author%> SIZE="20">*<br>
成果名称：<INPUT TYPE="TEXT" NAME="name" VALUE=<%=production%> SIZE="20">*<br>
获奖级别：<INPUT TYPE="TEXT" NAME="band" VALUE=<%out.print("'"+band+"'");%> SIZE="20"><br>
获奖时间：<INPUT TYPE="TEXT" NAME="time" VALUE=<%=time%> SIZE="20">*（格式：YYYY-MM-DD）<br>
证书编号：<INPUT TYPE="TEXT" NAME="number" VALUE=<%out.print("'"+number+"'");%> SIZE="20"><br><br>
<INPUT TYPE="SUBMIT" VALUE="修改">
<INPUT TYPE="RESET" VALUE="重填">
</FORM>
<%}%>
<%if (sort.equals("checkUp") && rs.next()){
String author=new String(rs.getString("author").toString().getBytes("8859_1"));
production=new String(production.toString().getBytes("8859_1"));
String band=new String(rs.getString("checkBand").toString().getBytes("8859_1"));
String level=new String(rs.getString("level").toString().getBytes("8859_1"));
String time=rs.getString("checkTime");
String rank=rs.getString("rank");
%>
<FORM action="modify2.jsp" method="GET">
请修改鉴定信息<br><br>
作者姓名：<INPUT TYPE="TEXT" NAME="author" VALUE=<%=author%> SIZE="20">*<br>
成果名称：<INPUT TYPE="TEXT" NAME="name" VALUE=<%=production%> SIZE="20">*<br>
鉴定级别：<INPUT TYPE="TEXT" NAME="checkBand" VALUE=<%out.print("'"+band+"'");%> SIZE="20"><br>
成果水平：<INPUT TYPE="TEXT" NAME="level" VALUE=<%out.print("'"+level+"'");%> SIZE="20"><br>
鉴定时间：<INPUT TYPE="TEXT" NAME="time" VALUE=<%=time%> SIZE="20">*（格式：YYYY-MM-DD）<br>
排列名次：<INPUT TYPE="TEXT" NAME="number" VALUE=<%out.print("'"+rank+"'");%> SIZE="20"><br><br>
<INPUT TYPE="SUBMIT" VALUE="修改">
<INPUT TYPE="RESET" VALUE="重填">
</FORM>
<%}%>
<%if (sort.equals("onStudy") && rs.next()){
String author=new String(rs.getString("author").toString().getBytes("8859_1"));
production=new String(production.toString().getBytes("8859_1"));
String band=new String(rs.getString("itemBand").toString().getBytes("8859_1"));
//if(band.equals("null"))band="";
double money=rs.getDouble("itemMoney");
String t0=rs.getString("t0").substring(0,4);
String t1=rs.getString("t1").substring(0,4);
%>
<FORM action="modify2.jsp" method="GET">
请修改在研项目信息<br><br>
主 持 人：<INPUT TYPE="TEXT" NAME="author" VALUE=<%=author%> SIZE="20">*<br>
项目名称：<INPUT TYPE="TEXT" NAME="name" VALUE=<%=production%> SIZE="20">*<br>
项目级别：<INPUT TYPE="TEXT" NAME="band" VALUE=<%out.print("'"+band+"'");%> SIZE="20"><br>
项目金额：<INPUT TYPE="TEXT" NAME="money" VALUE=<%=money%> SIZE="20">*（单位：元）<br>
起止年份：<INPUT TYPE="TEXT" NAME="t0" VALUE=<%=t0%> SIZE="4" MAXLENGTH=4>-- <INPUT TYPE="TEXT" NAME="t1" VALUE=<%=t1%> SIZE="4" MAXLENGTH=4>*（格式：YYYY）<br><br>
<INPUT TYPE="SUBMIT" VALUE="修改">
<INPUT TYPE="RESET" VALUE="重填">
</FORM>
<%}
stmt.close();
con.close();
}catch(ClassNotFoundException e){
System.out.println("未找到要加载的驱动类");
}catch(SQLException e){
System.out.println("SQL错误提示:"+e);
}
%>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -