学生学籍管理系统源代码.docx
《学生学籍管理系统源代码.docx》由会员分享,可在线阅读,更多相关《学生学籍管理系统源代码.docx(10页珍藏版)》请在冰豆网上搜索。
学生学籍管理系统源代码
学生学籍管理系统源代码
源代码:
连接数据库的代码:
packagecn.system.manage.tools;importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.sql.Statement;
publicclassDBAccess{
finalstaticprivateStringstrDriver="com.mysql.jdbc.Driver";
finalstaticprivateString
url="jdbc:
mysql:
//localhost:
3306/xjgl?
userUnicode=true&characterEncoding=gb2312
";
finalstaticprivateStringuser="root";
finalstaticprivateStringpassword="admin";
privatestaticDBAccessdb=null;
privateConnectioncon;
privateStatementstmt;
privateResultSetrst;
privateDBAccess(){
try{
Class.forName(strDriver);
con=DriverManager.getConnection(url,user,password);
stmt=con.createStatement();
}catch(ClassNotFoundExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}catch(SQLExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}
}
publicstaticDBAccessgetDBAccess(){
if(db==null){
db=newDBAccess();
}
returndb;
}
publicConnectiongetConnection(){
returncon;
}
publicResultSetquery(Stringsql){
try{
rst=stmt.executeQuery(sql);
}catch(SQLExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}
returnrst;
}
publicintupdate(Stringsql){
intflag=0;
try{
flag=stmt.executeUpdate(sql);
}catch(SQLExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
return-1;
}
returnflag;
}
publicvoidclose(){
try{
rst.close();
stmt.close();
con.close();
}catch(SQLExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}
}
publicResultSetqueryScroll(Stringsql)
{
try
{
stmt=con.createStatement(1004,1007);
returnstmt.executeQuery(sql);
}
catch(SQLExceptionsqlexception)
{
returnnull;
}
}
}
转换字符集代码:
packagecn.system.manage.tools;
importjava.io.IOException;
importjavax.servlet.Filter;
importjavax.servlet.FilterChain;
importjavax.servlet.FilterConfig;
importjavax.servlet.ServletException;importjavax.servlet.ServletRequest;
importjavax.servlet.ServletResponse;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;publicclassCharFilterimplementsFilter{
publicvoiddestroy(){
//TODOAuto-generatedmethodstub
}
publicvoiddoFilter(ServletRequestarg0,ServletResponsearg1,
FilterChainarg2)throwsIOException,ServletException{
//TODOAuto-generatedmethodstub
HttpServletRequestrequest=(HttpServletRequest)arg0;
HttpServletResponseresponse=(HttpServletResponse)arg1;
request.setCharacterEncoding("GBK");
response.setCharacterEncoding("GBK");
arg2.doFilter(arg0,arg1);
}
publicvoidinit(FilterConfigarg0)throwsServletException{
//TODOAuto-generatedmethodstub
}
}
分页代码:
packagecn.system.manage.tools;
importjava.io.Serializable;
importjava.util.ArrayList;
publicclassPageBeanimplementsSerializable{
ArrayListlist;
intpageNo;
intpageSize;
intpageSum;
introwCount;
intpagePrev;
intpageNext;
inthasFirst;
inthasPrev;
inthasNext;
inthasEnd;
publicPageBean()
{
list=null;
list=newArrayList();
}
publicArrayListgetList()
{
returnlist;
}
publicvoidsetPageInfo(intmyRowCount,intmyPageSize)
{
if(myPageSize>0)
{
setPageSize(myPageSize);
setRowCount(myRowCount);
if(myRowCount>0)
setPageSum(((myRowCount+myPageSize)-1)/myPageSize);
}
}
publicvoidsetList(ArrayListlist)
{
this.list=list;
}
publicintgetPageNo()
{
returnpageNo;
}
publicvoidsetPageNo(intpageNo)
{
this.pageNo=pageNo;
}
publicintgetPagePrev()
{
returnpageNo-1;
}
publicintgetPageNext()
{
returnpageNo+1;
}
publicintgetPageSum()
{
returnpageSum;
}
publicvoidsetPageSum(intpageSum)
{
this.pageSum=pageSum;
}
publicintgetHasPrev()
{
if(pageSum>1)
returnpageNo>=2?
1:
0;
else
return0;
}
publicintgetHasNext()
{
if(pageSum>1)
returnpageNo1:
0;
else
return0;
}
publicintgetHasFirst()
{
if(pageSum>1)
returnpageNo<=1?
0:
1;
else
return0;
}
publicintgetHasEnd()
{
if(pageSum>1)
returnpageNo>=pageSum?
0:
1;
else
return0;
}
publicintgetPageSize()
{
returnpageSize;
}
publicvoidsetPageSize(intpageSize)
{
this.pageSize=pageSize;
}
publicvoidsetPagePrev(intpagePrev)
{
this.pagePrev=pagePrev;
}
publicvoidsetHasPrev(inthasPrev)
{
this.hasPrev=hasPrev;
}
publicvoidsetHasNext(inthasNext)
{
this.hasNext=hasNext;
}
publicvoidsetHasFirst(inthasFirst)
{
this.hasFirst=hasFirst;
}
publicvoidsetHasEnd(inthasEnd)
{
this.hasEnd=hasEnd;
}
publicvoidsetPageNext(intpageNext)
{
this.pageNext=pageNext;
}
publicintgetRowCount()
{
returnrowCount;
}
publicvoidsetRowCount(introwCount)
{
this.rowCount=rowCount;
}
}