学生学籍管理系统源代码
源代码:
连接数据库的代码:
package cn.system.manage.tools; import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBAccess {
final static private String strDriver="com.mysql.jdbc.Driver";
final static private String
url="jdbc:mysql://localhost:3306/xjgl?userUnicode=true&characterEncoding=gb2312
";
final static private String user="root";
final static private String password="admin";
private static DBAccess db = null;
private Connection con;
private Statement stmt;
private ResultSet rst;
private DBAccess(){
try {
Class.forName(strDriver);
con=DriverManager.getConnection(url, user, password);
stmt=con.createStatement();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static DBAccess getDBAccess(){
if(db==null){
db= new DBAccess();
}
return db;
}
public Connection getConnection(){
return con;
}
public ResultSet query(String sql){
try {
rst=stmt.executeQuery(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return rst;
}
public int update(String sql){
int flag=0;
try {
flag=stmt.executeUpdate(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return -1;
}
return flag;
}
public void close(){
try {
rst.close();
stmt.close();
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public ResultSet queryScroll(String sql)
{
try
{
stmt = con.createStatement(1004, 1007);
return stmt.executeQuery(sql);
}
catch(SQLException sqlexception)
{
return null;
}
}
}
转换字符集代码:
package cn.system.manage.tools;
import java.io.IOException;
import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException; import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class CharFilter implements Filter {
public void destroy() {
// TODO Auto-generated method stub
}
public void doFilter(ServletRequest arg0, ServletResponse arg1,
FilterChain arg2) throws IOException, ServletException {
// TODO Auto-generated method stub
HttpServletRequest request = (HttpServletRequest)arg0;
HttpServletResponse response = (HttpServletResponse)arg1;
request.setCharacterEncoding("GBK");
response.setCharacterEncoding("GBK");
arg2.doFilter(arg0, arg1);
}
public void init(FilterConfig arg0) throws ServletException {
// TODO Auto-generated method stub
}
}
分页代码:
package cn.system.manage.tools;
import java.io.Serializable;
import java.util.ArrayList;
public class PageBean implements Serializable{
ArrayList list;
int pageNo;
int pageSize;
int pageSum;
int rowCount;
int pagePrev;
int pageNext;
int hasFirst;
int hasPrev;
int hasNext;
int hasEnd;
public PageBean()
{
list = null;
list = new ArrayList();
}
public ArrayList getList()
{
return list;
}
public void setPageInfo(int myRowCount, int myPageSize)
{
if(myPageSize > 0)
{
setPageSize(myPageSize);
setRowCount(myRowCount);
if(myRowCount > 0)
setPageSum(((myRowCount + myPageSize) - 1) / myPageSize);
}
}
public void setList(ArrayList list)
{
this.list = list;
}
public int getPageNo()
{
return pageNo;
}
public void setPageNo(int pageNo)
{
this.pageNo = pageNo;
}
public int getPagePrev()
{
return pageNo - 1;
}
public int getPageNext()
{
return pageNo + 1;
}
public int getPageSum()
{
return pageSum;
}
public void setPageSum(int pageSum)
{
this.pageSum = pageSum;
}
public int getHasPrev()
{
if(pageSum > 1)
return pageNo >= 2 ? 1 : 0;
else
return 0;
}
public int getHasNext()
{
if(pageSum > 1)
return pageNo < pageSum ? 1 : 0;
else
return 0;
}
public int getHasFirst()
{
if(pageSum > 1)
return pageNo <= 1 ? 0 : 1;
else
return 0;
}
public int getHasEnd()
{
if(pageSum > 1)
return pageNo >= pageSum ? 0 : 1;
else
return 0;
}
public int getPageSize()
{
return pageSize;
}
public void setPageSize(int pageSize)
{
this.pageSize = pageSize;
}
public void setPagePrev(int pagePrev)
{
this.pagePrev = pagePrev;
}
public void setHasPrev(int hasPrev)
{
this.hasPrev = hasPrev;
}
public void setHasNext(int hasNext)
{
this.hasNext = hasNext;
}
public void setHasFirst(int hasFirst)
{
this.hasFirst = hasFirst;
}
public void setHasEnd(int hasEnd)
{
this.hasEnd = hasEnd;
}
public void setPageNext(int pageNext)
{
this.pageNext = pageNext;
}
public int getRowCount()
{
return rowCount;
}
public void setRowCount(int rowCount)
{
this.rowCount = rowCount;
}
}
本文档为【学生学籍管理系统源代码】,请使用软件OFFICE或WPS软件打开。作品中的文字与图均可以修改和编辑,
图片更改请在作品中右键图片并更换,文字修改请直接点击文字进行修改,也可以新增和删除文档中的内容。
该文档来自用户分享,如有侵权行为请发邮件ishare@vip.sina.com联系网站客服,我们会及时删除。
[版权声明] 本站所有资料为用户分享产生,若发现您的权利被侵害,请联系客服邮件isharekefu@iask.cn,我们尽快处理。
本作品所展示的图片、画像、字体、音乐的版权可能需版权方额外授权,请谨慎使用。
网站提供的党政主题相关内容(国旗、国徽、党徽..)目的在于配合国家政策宣传,仅限个人学习分享使用,禁止用于任何广告和商用目的。