⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 subjectsave.jsp

📁 一个很实用的在线考试系统
💻 JSP
字号:
<%@ page language="java" import="java.util.*" pageEncoding="GB18030"%>
<%@ page import="com.study.database.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title>My JSP 'examsave.jsp' starting page</title>
  </head>
  
  <body>
    <%
    	DBConnectionManage db = new DBConnectionManage();
    	Connection conn = db.getFreeConnection();
    	String subjecttype = request.getParameter("subjecttype");
    	String subjectquestion = request.getParameter("subjectquestion");
    	String subjectanswer = request.getParameter("subjectanswer");
    	String query = "insert into subject (subjecttype,subjectquestion,subjectanswer) values(?,?,?)";
    	PreparedStatement psmt = null;
    	try{
    		
    		psmt = conn.prepareStatement(query);
    		psmt.setString(1,subjecttype);
    		psmt.setString(2,subjectquestion);
    		psmt.setString(3,subjectanswer);
    		psmt.executeUpdate();
    		out.println("<script language = javascript>alert('操作记录成功!');window.location.href='subject.jsp';</script>");
    		psmt.close();
    	}catch(Exception ex){
    		
    	}finally{
    		psmt.close();
    		conn.close();
    	}
    	
    %>
  </body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -