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

rt="java.sql.*" errorPage="" %>
<html>
<body bgcolor="#0099FF" text="#00FF00" link="#CCFF00">
<%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);
String id=request.getParameter("id");
String sql="select * from stu_info where id="+id+"";
ResultSet rs = stmt.executeQuery(sql);%>
<center class="style1">确定删除这个学生的记录吗?
<hr><%while(rs.next()){session.setAttribute("id",rs.getString("id"));%>
<p>学号:<%=rs.getString("id")%></p>
<p>姓名:<%=rs.getString("name")%></p>
<p>性别:<%=rs.getString("sex")%></p>
<p>年龄:<%=rs.getString("age")%></p>
<p>体重:<%=rs.getString("weight")%></p>
<%}rs.close();stmt.close();con.close();%>
<form name="form1" method="post" action="delete_2.jsp">
<input name="queding" type="submit" id="confirm" value="确定"> 
<input type="reset" name="back" id="back" value="返回">
</form><p> </p></center></body></html>

Delete_2.jsp: <%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<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);
String id=(String)session.getAttribute("id");
String sql="delete * from stu_info where id ="+id+"";
stmt.executeUpdate(sql);%>
<center><h2 class="style1">删除学生信息</h2><p><br>
<span class="style2">该学生记录已经被删除!</span></p>
<form name="form1" method="post" action="delete.jsp">
<input type="submit" id="back" name="back" value="返回"></form>
<p> </p></center></body></html>

Deleteuser.jsp: <%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<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_1user.jsp">
<p><span class=

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

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