一个简单的网页版学生系统,含修改,删除,详情,模糊删除
--主页面
实现代码
<form action="mhcx.jsp?wid=<%=request.getParameter("wid")%>"
align="center">
<input type="text" name="str"> <input type="submit"
value="查询">
</form>
<table border="1" align="center" width="80%" >
<tr>
<td>编号</td>
<td>姓名</td>
<td>密码</td>
<td>备注</td>
<td>操作</td>
</tr>
<%
//连接数据库 进行查询所有数据
//注册驱动类
Class.forName("oracle.jdbc.driver.OracleDriver");
//连接数据库
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
Connection con = DriverManager.getConnection(url, "scott", "scott");
//创建Pre对象
PreparedStatement ps = con.prepareStatement("select * from T277 order by uuid");
//执行sql语句
ResultSet rs = ps.executeQuery();
//处理结果-遍历结果集
while(rs.next()){
%>
<tr align="center">
<td><%=rs.getInt(1) %></td>
<td><%=rs.getString("uname") %></td>
<td><%=rs.getString("upwd&#