淮阴师范学院数据库课程设计
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse */
public void doPost(HttpServletRequest request, HttpServletResponse response)
// TODO Auto-generated method stub
response.setContentType(\); request.setCharacterEncoding(\); PrintWriter out=response.getWriter();
String action=request.getParameter(\);
if(action.trim().equals(\)){
String name=request.getParameter(\); String password=request.getParameter(\); Manager manager=new Manager(); manager.setName(name);
manager.setPassword(password); manager.newManager();
response)
throws ServletException, IOException {
out.print(\管理员创建成功！')\);
}
if(action.trim().equals(\)){
String name=request.getParameter(\); Manager manager=new Manager(); manager.setName(name); manager.deleteManager(); out.print(\
Language='JavaScript'>window.location='deleteManager.jsp'\);
out.print(\管理员删除成功！')\);
}
if(action.trim().equals(\)){
String name=request.getParameter(\); String password=request.getParameter(\); Manager manager=new Manager(); manager.setName(name);
manager.setPassword(password); manager.updateManager();
out.print(manager.getName()+\+manager.getPassword());
out.print(\密码修改成功，out.print(\
Language='JavaScript'>window.location='deleteManager.jsp'\);
15
淮阴师范学院数据库课程设计
将返回修改页面！')\); out.print(\
Language='JavaScript'>window.location='changePassword.jsp'\);
}
if(action.trim().equals(\)){
String bookName=request.getParameter(\); String bookAuthor=request.getParameter(\); String bookPublish=request.getParameter(\); String bookISBN=request.getParameter(\); String bookAmount=request.getParameter(\); Book book=new Book();
book.setBookName(bookName); book.setBookAmount(bookAmount); book.setBookAuthor(bookAuthor); book.setBookPublish(bookPublish); book.setBookISBN(bookISBN); book.newBook();
out.print(\图书添加成功！')\);
}
if(action.trim().equals(\)){
String name=request.getParameter(\); Book book=new Book(); book.setBookid(name); book.deleteBook(); out.print(name); out.print(\
Language='JavaScript'>window.location='addBook.jsp'\);
out.print(\图书删除成功！')\);
} /**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse */
public void doGet(HttpServletRequest request, HttpServletResponse response)
// TODO Auto-generated method stub }
out.print(\
Language='JavaScript'>window.location='deleteBook.jsp'\);
response)
throws ServletException, IOException {
16
淮阴师范学院数据库课程设计
}
}
doPost(request,response);
5.2.3有关数据库操作的SQL语句
Book.java
package javabean;
import publicclass.DatabaseConnection; public class Book {
protected String bookName; protected String bookid; protected String bookAuthor; protected String bookPublish; protected String bookISBN; protected String bookAmount;
public void setBookName(String bookName){ }
public String getBookName(){ }
public void setBookid(String bookid){ }
public String getBookid(){ }
public void setBookAuthor(String bookAuthor){ }
public String getBookAuthor(){ }
public void setBookPublish(String bookPublish){ }
public String getBookPublish(){ }
17
this.bookName=bookName;
return bookName;
this.bookid=bookid;
return bookid;
this.bookAuthor=bookAuthor;
return bookAuthor;
this.bookPublish=bookPublish;
return bookPublish;
淮阴师范学院数据库课程设计
public void setBookISBN(String bookISBN){ }
public String getBookISBN(){ }
public void setBookAmount(String bookAmount){ }
public String getBookAmount(){ }
public void newBook(){
String sql=\return bookAmount;
this.bookAmount=bookAmount; return bookISBN;
this.bookISBN=bookISBN;
book(bookname,bookauthor,bookpublish,bookISBN,bookamount)
values('\+bookName+\+bookAuthor+\+bookPublish+\+bookISBN+\+bookAmount+\; }
}
public void deleteBook(){ }
String sql=\+bookid; System.out.println(sql);
DatabaseConnection dc=new DatabaseConnection(); dc.execute(sql);
System.out.println(sql);
DatabaseConnection dc=new DatabaseConnection(); dc.execute(sql);
Manager.java
package javabean; import java.sql.*; import java.text.*;
import publicclass.DatabaseConnection; public class Manager {
protected String name; protected String password;
public void setName(String name){ }
this.name=name;
18
淮阴师范学院数据库课程设计
}
public String getName(){ }
public void setPassword(String password){ }
public String getPassword(){ }
public boolean loginManager() throws SQLException{ }
public Manager newManager(){ }
public void deleteManager(){ }
public void updateManager(){ }
String sql=\+name+\+password+\DatabaseConnection dc=new DatabaseConnection(); dc.execute(sql);
String sql=\+name+\; DatabaseConnection dc=new DatabaseConnection(); dc.execute(sql);
String sql=\+name+\+password+\; DatabaseConnection dc=new DatabaseConnection(); dc.execute(sql); return null;
String sql=\+name+\DatabaseConnection dc=new DatabaseConnection(); ResultSet rs=dc.getResult(sql); if(rs.next()){
return true; return false; }else{ }
return password;
this.password=password; return name;
password='\+password+\;
where name='\+name+\;
19