index.jsp页面:绑定所有的学生信息(类似新闻中的admin页面)
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<script language="javascript">
function clickdel() {
return confirm("删除请点击确认");
}
</script>
</head>
<body background = 'images/1.jpg'>
<form action = 'index.jsp'>
<div align = 'center'>
<a style = 'color:pink' href = "add.jsp">添加</a>
<input type = 'text' name = 'str'>
<input type = 'submit' value = '查询'>
</div>
</form>
<div align="center">
<ul>
<%
String str = request.getParameter("str");
String sql = "select * from T277 order by uuid";
if(str != null){
sql = "select * from T277 where uname like '%"+str+"%'";
}
//注册驱动类
Class.forName("oracle.jdbc.driver.OracleDriver");
//连接数据库
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
Connection con = DriverManager.getConnection(url, "scott", "tiger");
//创建Pre对象
PreparedStatement ps = con.prepareStatement(sql);
//执行sql语句
ResultSet rs = ps.executeQuery();
//处理结果-遍历结果集
while (rs.next()) {
%>
<li><%=rs.getString("uname")%>
<%out.print(" "+" "+" "); %>
<%=rs.getString("upwd")%>
<%out.print("&