📄 lian.jsp

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

💻 JSP

字号:

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
  <html>
<head><title>1111111</title>
     <META http=equiv="Content-Type" content="text/html;charset=GBK">
</head>
  <body>
    <%
  String name=request.getParameter("name");
  if(name==null)
   {
      name="";
   }
  /* byte b[]=name.getBytes("ISO-8859-1");
  name=new String(b);
  Connection con;
  Statement sql;
  ResultSet rs;*/
 
  try
   {
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   }
    catch(ClassNotFoundException e){}
   try
   {
     String url="jdbc:odbc:conn";
    Connection con=DriverManager.getConnection(url);
    Statement stmt=con.createStatement();
    String sql="select * from stuInfo";
    rs=sql.executeQuery("select * from stuInfo where stuName like '%"+name+"%'");
     %>
  <center>
    <h2>按姓名查找的学生信息：</h2>
  <br/>
  <br/>
  <h4>输出姓名为<%=name%>的学生信息:</h4>
    <table border="1" bgcolor="red">
     <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.getString(4)%></td>
        <td><%=rs.getString(5)%></td>
       </tr>
    <%}%>
    </table>
  </center>
   <%
   rs.close();
   stmt.close();
   con.close();
   }
    catch(SQLException e1){}
   %>
 </body>
 </html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -