📄 submit1.jsp
字号:
<%@ page session="true"%>
<%@ page contentType="text/html;charset=gb2312" %>
<HTML>
<HEAD>
<TITLE>submit</TITLE>
</HEAD>
<BODY>
<%@ page language="java" import="java.sql.*,javax.sql.*;" %>
[<a href="submit.html" target=3>返回</a>]
<%
String sort=(String)session.getAttribute("sort");
String name=(String)session.getAttribute("user");
//out.println("<hr>"+name+"<hr>");
if(!name.equals("over")){
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 (sort.equals("getAward")){
String author=(String)request.getParameter("author");
String production=(String)request.getParameter("name");
String awardBand=(String)request.getParameter("band");
String time=request.getParameter("time");
String number=(String)request.getParameter("number");
stmt.executeUpdate("insert into getAward values('"+author+"','"+production+"','"+awardBand+"','"+time+"','"+number+"')");
%>
<hr>提交成功！<hr>
<%}%>
<%if (sort.equals("checkUp")){
String author=request.getParameter("author");
String production=request.getParameter("name");
String checkBand=request.getParameter("checkBand");
String level=request.getParameter("level");
String checkTime=request.getParameter("time");
String rank=request.getParameter("number");
stmt.executeUpdate("insert into checkUp values('"+author+"','"+production+"','"+checkBand+"','"+level+"','"+checkTime+"','"+rank+"')");
%>
<hr>提交成功！<hr>
<%}%>
<%if (sort.equals("onStudy")){
String author=(String)request.getParameter("author");
String production=(String)request.getParameter("name");
String itemBand=(String)request.getParameter("band");
double itemMoney=Double.parseDouble(request.getParameter("money"));
String t0=request.getParameter("t0");
String t1=request.getParameter("t1");
stmt.executeUpdate("insert into onStudy values('"+author+"','"+production+"','"+itemBand+"',"+itemMoney+",'"+t0+"','"+t1+"')");
%>
<hr>
提交成功！
<hr>
<%}
stmt.close();
con.close();
System.out.println("提交成功！");
}catch(ClassNotFoundException e){
System.out.println("未找到要加载的驱动类");
}catch(SQLException e){
System.out.println("SQL错误提示:"+e);
}
}else{%>
<br>
<br>
<h1 align="center"><font color="00ff00" size=5>教师科研信息管理系统</font></h1>
<hr color="#ff8000">
<p>
<center>
请先[<a href="login.html" target=3>登录</a>]
</center>
</p>
<%}%>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -