continueadd.jsp

来自「用java+servlet实现在线考试系统」· JSP 代码 · 共 63 行

JSP
63
字号
<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="ISO-8859-1"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'continueadd.jsp' starting page</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->

  </head>
  
  <body>
   <%
     request.setCharacterEncoding("gbk");
     String stu_id=request.getParameter("textfield");
     String stu_num=request.getParameter("textfield3");
     String stu_name=request.getParameter("textfield2");
     String class_name=request.getParameter("textfield4");
     String stu_mail=request.getParameter("textfield7");
     String humanid=request.getParameter("textfield8");
     String address=request.getParameter("textfield5");
     String stu_phone=request.getParameter("textfield6");
     System.out.println(stu_id+stu_num+stu_name);
     String sql="insert into exam_student values('";
     sql+=stu_id+"','";
     sql+=stu_num+"','";
     sql+=stu_name+"','";
     sql+=class_name+"','";
     sql+=stu_mail+"','";
     sql+=humanid+"','";
     sql+=address+"','";
     sql+=stu_phone+"')";
     System.out.println(sql);
     String url="jdbc:oracle:thin:@localhost:1521:lihao";
     Class.forName("oracle.jdbc.driver.OracleDriver");
     Connection con=DriverManager.getConnection(url,"lihao","lihao");
     Statement sta =con.createStatement();
     int rows=sta.executeUpdate(sql);
     if(rows==1)
     {
        response.sendRedirect("AddUser.jsp?flag=success");
     }else
     {
        response.sendRedirect("AddUser.jsp?flag=nosuccess");
     
     }
    %>
  </body>
</html>

⌨️ 快捷键说明

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