管理员操作3
管理员第三个功能实现就是删除图书信息,同样要求在一个页面中输入即将要删除的图书名称,然后删除数据库中的图书信息。
删除页面deletebook.jsp
<%@ page language="java" contentType="text/html; charset=gb2312"
pageEncoding="gb2312"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>删除图书</title>
</head>
<body background=C:\Users\Administrator\Desktop\image\2.jpg>
<form action="deletebook1.jsp" method="post">
请输入书名:
<input type=text name=name><br><br>
<input type="submit" name=button value="删除">
</form>
</body>
</html>
deletebook1.jsp对数据库进行删除更新
<%@ page language="java" contentType="text/html; charset=gb2312"
pageEncoding="gb2312"%>
<%@page import="java.sql.*,java.io.*,java.lang.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<% String s=request.getParameter("name");
String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String USER = "sa";
String PASSWORD = "123456";
String URL = "jdbc:sqlserver://localhost:1433;databaseName=book";
Class.forName(DRIVER);
Connection conn=DriverManager.getConnection(URL, USER, PASSWORD);
Statement stmt=conn.createStatement();
String sql="delete from bookinfo where bookName='"+s+"'";
stmt.executeUpdate(sql);
out.print("删除成功!");
%>
</body>
</html>