基于jsp实现-图书馆信息管理系统.

page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<body bgcolor="#0099FF">
<CENTER>
<%Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //载入驱动程序类别
String url = "jdbc:odbc:studentdata";
String user="";String pwd="";
Connection con = DriverManager.getConnection(url,user, pwd); //建立数据库链接,studentdata为ODBC数据源名称
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery("SELECT * FROM user"); //建立ResultSet(结果集)对象，并执行SQL语句
rs.last(); //移至最后一条记录%>
<P>用户数据表中共有<FONT SIZE = 4 COLOR = red>
<%= rs.getRow() %></FONT>笔记录</P>
<TABLE border=2 bordercolor= #3333FF width=500 >
<TR bgcolor=CCCCCC ALIGN=CENTER><TD><B>记录数</B></TD>
<TD><B>姓名</B></TD><TD><B>密码</B></TD></TR>
<%rs.beforeFirst(); //移至第一条记录之前
//利用while循环配合next方法将数据表中的记录列出
while(rs.next()){ %>
<TR ALIGN=CENTER>
<TD><B><%= rs.getRow() %></B></TD>
<TD><B><%= rs.getString("name") %></B></TD>
<TD><B><%= rs.getString("password") %></B></TD>
</TR><% }
rs.close(); //关闭ResultSet对象
stmt.close(); //关闭Statement对象
con.close(); //关闭Connection对象%> </TABLE></CENTER></body></html>

delete.jsp: <%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<style type="text/css">
</style>
<body bgcolor="#0099FF">
<%Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //载入驱动程序类别
String url = "jdbc:odbc:studentdata";String user="";String pwd="";
Connection con = DriverManager.getConnection(url,user, pwd); //建立数据库链接,studentdata为ODBC数据源名称
//建立Statement对象
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);%>
<center> <h2 class="style1">删除学生信息</h2>
<br><form name="form1" method="post" action="delete_1.jsp">
<p><span class="style3">请选择要删除的学生的学号:</span>
    <select name="id">
      <% ResultSet rs = stmt.executeQuery("SELECT * FROM stu_info");
while(rs.next())
{ String id=rs.getString("id"); %>
   <option value="<%=id%>"><%=id%></option>
      <%}%>
}
</select></p><p><input type="submit" name="queding" value="确定">
 <input name="back" type="button" id="back" value="返回" onClick="java script:history.go(-1)">
</p></form></center></body></html>

Delete_1.jsp: <%@ page contentType="text/html; charset=gb2312" language="java" impo

首页上一页 5 6 7 8 9 10 11 下一页尾页 8/11/11

基于jsp实现-图书馆信息管理系统.(八)