学生学籍管理系统源代码
源代码：
连接数据库的代码：
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.i