📄 cha1.jsp

📁 简单的登录页面有增删改查功能

💻 JSP

字号:

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
  <%
    String agemin=request.getParameter("agemin");
    if(agemin==null)
    {
        agemin="0";
    }
    String agemax=request.getParameter("agemax");
    if(agemax==null)
    {
        agemax="100";
    }
    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 WHERE stuAge <=  "+agemax+" AND stuAge >= "+agemin+"");
     <center>
        <h2>按年龄查找的学生信息</h2>
        <br />
        <br />
        <h4>输出年龄在<%=agemin%>与<%=agemax%>之间的学生信息:</h4>
        <table border="1" bgcolor="blue">
            <tr>
                <th width="50">学号</th>
                <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.getString(3)%></td>
                <td><%=rs.getInt(4)%></td>
                <td><%=rs.getString(5)%></td>
            </tr>
            <%}%>
        </table>
    </center>
    
    <%}%>
   <%rs.close();
   stmt.close();
   con.close();
   %>
 </body>
 </html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -