1.jsp
来自「简单的登录页面有增删改查功能」· JSP 代码 · 共 68 行
JSP
68 行
<%@ 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/2.jpg">
<%
String name=request.getParameter("name");
if(name==null)
{
name="";
}
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";
ResultSet rs=stmt.executeQuery("select * from stuInfo");
%>
<center>
<h2>查找的学生信息为:</h2>
<br />
<br />
<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.getString(3)%></td>
<td><%=rs.getString(4)%></td>
</tr>
<%}%>
</table>
</center>
<%rs.close();
stmt.close();
con.close();
}
catch(SQLException e1)
{
System.out.println(e1);
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?