useBeanid="alogin"scope="page"class="org.pan.web.login"/>
<%
Stringmesg="";
StringadminName=request.getParameter（"adminName"）;
Stringpassword=request.getParameter（"password"）;
if（null==adminName）adminName="";
if（null==password）password="";
if（!
adminName.equals（""）&&!
password.equals（""））{
adminName=newString（adminName.getBytes（"ISO8859-1"））;
password=newString（password.getBytes（"ISO8859-1"））;
alogin.setAdminName（adminName）;
alogin.setPassword（password）;
if（alogin.excute（））{
session.setAttribute（"adminName",adminName）;
response.sendRedirect（"index.jsp"）;
}else{
mesg=alogin.errorMessage ;
}
}
%>
4.2主界面功能
主界面
对所有功能的增删改的数据库方法声明处理封装在一个java文件中
publicDataBase（）{
try
{
DBConnectionManagerdcm=newDBConnectionManager（）;
conn=dcm.getConnection（）;
stmt=conn.createStatement（）;
}
catch（Exceptione）
{
System.out.println（e）;
isConnect=false;
}
}
publicStatementgetStatement（）{
returnstmt;
}
publicConnectiongetConnection（）{
returnconn;
}
publicPreparedStatementgetPreparedStatement（）{
returnprepstmt;
}
publicResultSetgetResultSet（）{
returnrs;
}
publicbooleanexecute（）throwsException{
returnfalse;
}
publicbooleaninsert（）throwsException{
returnfalse;
}
publicbooleanupdate（）throwsException{
returnfalse;
}
publicbooleandelete（）throwsException{
returnfalse;
}
publicbooleanquery（）throwsException{
returnfalse;
}
publicvoidclose（）throwsSQLException{
if（stmt!
=null）
{
stmt.close（）;
stmt=null;
}
conn.close（）;
conn=null;
}
模糊查询的核心数据库部分代码
sqlStr="select*fromemployee";
if（searchZiduan.equals（""）&&!
keyword.equals（""））{
sqlStr=sqlStr+"whereemployeeIdlike'%"+keyword+"%'ornamelike'%"+keyword+"%'ordepartmentlike'%"+keyword+"%'orderbyemployeeIddesc";
}elseif（!
searchZiduan.equals（""））{
sqlStr=sqlStr+"where"+searchZiduan+"like'%"+keyword+"%'orderbyemployeeIddesc";
}elseif（searchZiduan.equals（""）&&keyword.equals（""））{
sqlStr=sqlStr+"orderbyemployeeIddesc";
}
分页方法声明处理
publicintgetPage（）{
returnpage;
}
publicvoidsetPage（intnewpage）{
page=newpage;
}
publicintgetPageSize（）{
returnpageSize;
}
publicvoidsetPageSize（intnewpsize）{
pageSize=newpsize;
}
publicintgetPageCount（）{
returnpageCount;
}
publicvoidsetPageCount（intnewpcount）{
pageCount=newpcount;
}
publiclonggetRecordCount（）{
returnrecordCount;
}
publicvoidsetRecordCount（longnewrcount）{
recordCount=newrcount;
}
分页功能的一个具体实现//
publicbooleanexecute（HttpServletRequestres）throwsException{
request=res;
StringPAGE=request.getParameter（"page"）;
StringsearchZiduan=request.getParameter（"searchZiduan"）;
Stringkeyword=request.getParameter（"keyword"）;
if（keyword==null）keyword="";
if（searchZiduan==null）searchZiduan="";
keyword=getGbk（keyword）;
searchZiduan=getGbk（searchZiduan）;
try
{
page=Integer.parseInt（PAGE）;
}
catch（NumberFormatExceptione）
{
page=1;
}
intrscount=pageSize;
try
{
ResultSetrs1=stmt.executeQuery（sqlStr）;
if（rs1.next（））recordCount=rs1.getInt
（1）;
rs1.close（）;
}
catch（SQLExceptione）
{
errorMessage=""+searchZiduan+sqlStr+e.getMessage（）;
returnfalse;
}
if（recordCount<1）
pageCount=0;
else
pageCount=（int）（recordCount-1）/pageSize+1;
if（page<1）
page=1;
elseif（page>pageCount）
page=pageCount;
rscount=（int）recordCount%pageSize;
sqlStr="select*fromemployee";
try
{
rs=stmt.executeQuery（sqlStr）;
employeelist=newVector（rscount）;
for（inti=0;i while（rs.next（））
{
employeeanemployee=newemployee（）;
anemployee.setEmployeeId（rs.getString（"employeeId"））;
anemployee.setName（rs.getString（"name"））;
anemployee.setCardNumber（rs.getString（"cardNumber"））;
anemployee.setNation（rs.getString（"nation"））;
anemployee.setSex（rs.getString（"sex"））;
anemployee.setBirthday（rs.getString（"birthday"））;
anemployee.setGraduateSchool（rs.getString（"graduateSchool"））;
anemployee.setSchoolRecord（rs.getString（"schoolRecord"））;
a
升级会员 