淮阴师范学院数据库课程设计
}
ResultSet rs=null;
public void connection(){ }
public void execute(String sql){ }
public ResultSet getResult(String sql) throws SQLException{ }
public ResultSet executeQuery(String sql)throws Exception{
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCU }
}
return rs;
rs=stmt.executeQuery(sql);
System.out.println(\+e.getMessage()); connection(); try{
sql=new String(sql.getBytes(\),\); connection(); try{ }
rs=stmt.executeQuery(sql); return rs;
System.out.println(e); return null; connection(); try{ }
stmt.executeUpdate(sql);
System.out.println(e.toString()); }catch(Exception e){ try{ }
Class.forName(\);
con=DriverManager.getConnection(\); stmt=con.createStatement(); System.out.println(e.toString());
}catch(Exception e){
}catch(Exception e){
R_READ_ONLY);
}catch(SQLException e){
10
淮阴师范学院数据库课程设计
5.2学生模块设计
5.2.1分页显示图书信息（采用JavaBean）
Pageination.java package javabean; import java.sql.*; import java.math.*;
import javax.servlet.http.*;
public class Pageination { private String strPage=null; private int curPages; private int m_rows; //每页显示的记录数 private int pages; //总页数 public String strPage(HttpServletRequest request, String page){ try{ strPage=request.getParameter(page); }catch(Exception e){ System.out.println(e.getMessage()); } return strPage; } public int curPages(String strPage){ try{ if(strPage==null){ curPages=1; }else{ curPages=Integer.parseInt(strPage); if(curPages<1){ curPages=1; } } }catch(Exception e){ System.out.println(\ } return curPages; } public int getPages(int rowcounts){ int test;
11
淮阴师范学院数据库课程设计
}
test=rowcounts % m_rows; if(test==0){ pages=rowcounts/m_rows; }else{ pages=rowcounts/m_rows+1; } return pages; }
public ResultSet getPageSet(ResultSet rs,int curPages){ if(curPages==1){ return rs; }else{ int i=1; try{ while(rs.next()){ i=i+1; if(i>((curPages-1)*m_rows)) break; } return rs; }catch(Exception e){ System.out.println(e.getMessage()); } } return rs; }
public void setRows(int rows){ m_rows=rows; }
StudentServlet.java
package servlet;
import java.io.IOException; import java.io.PrintWriter;
import javax.servlet.ServletException; import javax.servlet.http.*;
import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javabean.Manager;
12
淮阴师范学院数据库课程设计
/**
* Servlet implementation class StudentServlet */
public class StudentServlet extends HttpServlet { public StudentServlet() { super();
// TODO Auto-generated constructor stub }
//处理中文乱码的函数
public String getS(String s){
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse */
public void doPost(HttpServletRequest request, HttpServletResponse response)
// TODO Auto-generated method stub
response.setContentType(\); PrintWriter out=response.getWriter();
String action=request.getParameter(\);
if(action.trim().equals(\)){
try{
String name=request.getParameter(\);
String password=request.getParameter(\); Manager manager=new Manager(); name=getS(name);
password=getS(password); manager.setName(name);
manager.setPassword(password); if(manager.loginManager()){
HttpSession session=request.getSession(); session.setAttribute(\, name);
}
try{ }
byte b[]=s.getBytes(\); s=new String(b); return s;
return e.toString();
}catch(Exception e){
response)
throws ServletException, IOException {
13
淮阴师范学院数据库课程设计
session.setAttribute(\, password); response.sendRedirect(\);
out.print(\用户名
}else{
和密码错误，请重新输入！')\); out.print(\
Language='JavaScript'>window.location='managerLogin.jsp'\); }
} /**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse */
public void doGet(HttpServletRequest request, HttpServletResponse response) }
// TODO Auto-generated method stub doPost(request,response); }
}
}
System.out.println(e);
}catch(Exception e){
response)
throws ServletException, IOException {
5.2.2管理员模块的实现
ManagerServlet.java
package servlet; import java.io.*; import java.sql.*; import java.util.*; import javax.servlet.*; import javax.servlet.http.*;
import javax.servlet.ServletException; import javabean.Manager; import javabean.Book; /**
* Servlet implementation class ManagerServlet */
public class ManagerServlet extends HttpServlet {
/**
14