📄 3.jsp

📁 简单的登录页面有增删改查功能
💻 JSP
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
  <head>
        <title>插入后的学生信息</title>
        <META http-equiv="Content-Type" content="text/html; charset=GB2312">
    </head>
<body background="./image/4.jpg">
  <%
  String name=request.getParameter("name");
    if(name==null)
    {
        name="";
    } 
     byte n[]=name.getBytes("ISO-8859-1");
        name=new String(n);
        
        String sex=request.getParameter("sex");
        if(sex==null)
        {
            sex="";
        }
         byte s[]=sex.getBytes("ISO-8859-1");
        sex=new String(s);
        
        String age=request.getParameter("age");
        
        String dept=request.getParameter("dept");
        if(dept==null)
        {
            dept="";
        }
        byte d[]=dept.getBytes("ISO-8859-1");
        dept=new String(d);
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    String url="jdbc:odbc:conn";
    Connection con=DriverManager.getConnection(url);
    Statement stmt=con.createStatement();
    ResultSet rs=stmt.executeQuery("select * from stuInfo");
    stmt.executeUpdate("INSERT INTO stuInfo VALUES('"+name+"','"+sex+"','"+age+"','"+dept+"')");
     System.out.print("INSERT INTO stuInfo VALUES('"+name+"','"+sex+"','"+age+"','"+dept+"'");
     rs=stmt.executeQuery("SELECT* FROM stuInfo");
   
    %>
            <center>
                <h2>学生信息表</h2>
                <br />
                <br />
                <h4>输出插入后的学生信息:</h4>
                <table border="1" bgcolor="green">
                    <tr>
                        <th width="50">姓名</th>
                        <th width="50">性别</th>
                        <th width="50">年龄</th>
                        <th width="50">系别</th>
                    </tr>
                    <%
                    while(rs.next())
                    {%>
                    <tr>
                        <td><%=rs.getString(1)%></td>
                        <td><%=rs.getString(2)%></td>
                        
                        <td><%=rs.getInt(3)%></td>
                        <td><%=rs.getString(4)%></td>
                    </tr>
                    <%}%>
                </table>
            </center>
            <%rs.close();
   stmt.close();
   con.close();
   %>
 </body>
 </html>
⌨️ 快捷键说明

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