📄 modify.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>]<br><br>
请选择要修改的项目：
<%
String name=(String)session.getAttribute("user");
//out.println("<hr>"+name+"<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();
if (request.getParameter("sort").equals("getAward")){
session.setAttribute("sort","getAward");
ResultSet rs=stmt.executeQuery("select * from getAward where author='"+name+"'");
out.println("<form action='modify1.jsp' method='GET'>");
while(rs.next()){
String tmp=rs.getString("production");
tmp=new String(tmp.toString().getBytes("8859_1"));
out.println("<br><INPUT TYPE='RADIO' NAME='production' VALUE='"+tmp+"' CHECKED='true'>" + tmp + "<br>");
}
out.println("<br><hr><center><INPUT TYPE='SUBMIT' VALUE='下一步'></center></form>");
rs.close();
}
if (request.getParameter("sort").equals("checkUp")){
session.setAttribute("sort","checkUp");
ResultSet rs=stmt.executeQuery("select * from checkUp where author='"+name+"'");
out.println("<form action='modify1.jsp' method='GET'>");
while(rs.next()){
String tmp=rs.getString("production");
tmp=new String(tmp.toString().getBytes("8859_1"));
out.println("<br><INPUT TYPE='RADIO' NAME='production' VALUE='"+tmp+"' CHECKED='true'>" + tmp + "<br>");
}
out.println("<br><hr><center><INPUT TYPE='SUBMIT' VALUE='下一步'></center></form>");
rs.close();
}
if (request.getParameter("sort").equals("onStudy")){
session.setAttribute("sort","onStudy");
ResultSet rs=stmt.executeQuery("select * from onStudy where author='"+name+"'");
out.println("<form action='modify1.jsp' method='GET'>");
while(rs.next()){
String tmp=rs.getString("production");
tmp=new String(tmp.toString().getBytes("8859_1"));
out.println("<br><INPUT TYPE='RADIO' NAME='production' VALUE='"+tmp+"' CHECKED='true'>" +tmp+ "<br>");
}
out.println("<br><hr><center><INPUT TYPE='SUBMIT' VALUE='下一步'></center></form>");
rs.close();
}
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 + -