dbconnmanager.java
来自「Java课程项目—学生管理系统是北航软件学院2005级大三上学期的选修课期末大作」· Java 代码 · 共 1,541 行 · 第 1/5 页
JAVA
1,541 行
"ORDER BY chinese DESC";
}
else if (!bymath.equals("")) {
bygrade = "math";
sqlquery = "SELECT stu_id,math,class FROM stugrade_352111 " +
"UNION SELECT stu_id,math,class FROM stugrade_352112 " +
"UNION SELECT stu_id,math,class FROM stugrade_352113 " +
"UNION SELECT stu_id,math,class FROM stugrade_352114 " +
"UNION SELECT stu_id,math,class FROM stugrade_352115 " +
"UNION SELECT stu_id,math,class FROM stugrade_352116 " +
"ORDER BY math DESC";
}
else if (!byenglish.equals("")) {
bygrade = "english";
sqlquery = "SELECT stu_id,english,class FROM stugrade_352111 " +
"UNION SELECT stu_id,english,class FROM stugrade_352112 " +
"UNION SELECT stu_id,english,class FROM stugrade_352113 " +
"UNION SELECT stu_id,english,class FROM stugrade_352114 " +
"UNION SELECT stu_id,english,class FROM stugrade_352115 " +
"UNION SELECT stu_id,english,class FROM stugrade_352116 " +
"ORDER BY english DESC";
}
else if (!bycomposite.equals("")) {
bygrade = "composite";
sqlquery = "SELECT stu_id,composite,class FROM stugrade_352111 " +
"UNION SELECT stu_id,composite,class FROM stugrade_352112 " +
"UNION SELECT stu_id,composite,class FROM stugrade_352113 " +
"UNION SELECT stu_id,composite,class FROM stugrade_352114 " +
"UNION SELECT stu_id,composite,class FROM stugrade_352115 " +
"UNION SELECT stu_id,composite,class FROM stugrade_352116 " +
"ORDER BY composite DESC";
}
else {
bygrade = "total";
sqlquery = "SELECT stu_id,total,class FROM stugrade_352111 " +
"UNION SELECT stu_id,total,class FROM stugrade_352112 " +
"UNION SELECT stu_id,total,class FROM stugrade_352113 " +
"UNION SELECT stu_id,total,class FROM stugrade_352114 " +
"UNION SELECT stu_id,total,class FROM stugrade_352115 " +
"UNION SELECT stu_id,total,class FROM stugrade_352116 " +
"ORDER BY total DESC";
}
}
if (!aclass.equals("")) { //班级成绩排名
if (aclass.equals("352111")) {
if (!bychinese.equals("")) {
bygrade = "chinese";
sqlquery = "select stu_id, chinese, class from stugrade_352111 " +
"ORDER BY chinese DESC";
}
else if (!bymath.equals("")) {
bygrade = "math";
sqlquery = "select stu_id, math, class from stugrade_352111 " +
"ORDER BY math DESC";
}
else if (!byenglish.equals("")) {
bygrade = "english";
sqlquery = "select stu_id, english, class from stugrade_352111 " +
"ORDER BY english DESC";
}
else if (!bycomposite.equals("")) {
bygrade = "composite";
sqlquery = "select stu_id, composite, class from stugrade_352111 " +
"ORDER BY composite DESC";
}
else {
bygrade = "total";
sqlquery = "select stu_id, total, class from stugrade_352111 " +
"ORDER BY total DESC";
}
}
else if (aclass.equals("352112")) {
if (!bychinese.equals("")) {
bygrade = "chinese";
sqlquery = "select stu_id, chinese, class from stugrade_352112 " +
"ORDER BY chinese DESC";
}
else if (!bymath.equals("")) {
bygrade = "math";
sqlquery = "select stu_id, math, class from stugrade_352112 " +
"ORDER BY math DESC";
}
else if (!byenglish.equals("")) {
bygrade = "english";
sqlquery = "select stu_id, english, class from stugrade_352112 " +
"ORDER BY english DESC";
}
else if (!bycomposite.equals("")) {
bygrade = "composite";
sqlquery = "select stu_id, composite, class from stugrade_352112 " +
"ORDER BY composite DESC";
}
else {
bygrade = "total";
sqlquery = "select stu_id, total, class from stugrade_352112 " +
"ORDER BY total DESC";
}
}
else if (aclass.equals("352113")) {
if (!bychinese.equals("")) {
bygrade = "chinese";
sqlquery = "select stu_id, chinese, class from stugrade_352113 " +
"ORDER BY chinese DESC";
}
else if (!bymath.equals("")) {
bygrade = "math";
sqlquery = "select stu_id, math, class from stugrade_352113 " +
"ORDER BY math DESC";
}
else if (!byenglish.equals("")) {
bygrade = "english";
sqlquery = "select stu_id, english, class from stugrade_352113 " +
"ORDER BY english DESC";
}
else if (!bycomposite.equals("")) {
bygrade = "composite";
sqlquery = "select stu_id, composite, class from stugrade_352113 " +
"ORDER BY composite DESC";
}
else {
bygrade = "total";
sqlquery = "select stu_id, total, class from stugrade_352113 " +
"ORDER BY total DESC";
}
}
else if (aclass.equals("352114")) {
if (!bychinese.equals("")) {
bygrade = "chinese";
sqlquery = "select stu_id, chinese, class from stugrade_352114 " +
"ORDER BY chinese DESC";
}
else if (!bymath.equals("")) {
bygrade = "math";
sqlquery = "select stu_id, math, class from stugrade_352114 " +
"ORDER BY math DESC";
}
else if (!byenglish.equals("")) {
bygrade = "english";
sqlquery = "select stu_id, english, class from stugrade_352114 " +
"ORDER BY english DESC";
}
else if (!bycomposite.equals("")) {
bygrade = "composite";
sqlquery = "select stu_id, composite, class from stugrade_352114 " +
"ORDER BY composite DESC";
}
else {
bygrade = "total";
sqlquery = "select stu_id, total, class from stugrade_352114 " +
"ORDER BY total DESC";
}
}
else if (aclass.equals("352115")) {
if (!bychinese.equals("")) {
bygrade = "chinese";
sqlquery = "select stu_id, chinese, class from stugrade_352115 " +
"ORDER BY chinese DESC";
}
else if (!bymath.equals("")) {
bygrade = "math";
sqlquery = "select stu_id, math, class from stugrade_352115 " +
"ORDER BY math DESC";
}
else if (!byenglish.equals("")) {
bygrade = "english";
sqlquery = "select stu_id, english, class from stugrade_352115 " +
"ORDER BY english DESC";
}
else if (!bycomposite.equals("")) {
bygrade = "composite";
sqlquery = "select stu_id, composite, class from stugrade_352115 " +
"ORDER BY composite DESC";
}
else {
bygrade = "total";
sqlquery = "select stu_id, total, class from stugrade_352115 " +
"ORDER BY total DESC";
}
}
else if (aclass.equals("352116")) {
if (!bychinese.equals("")) {
bygrade = "chinese";
sqlquery = "select stu_id, chinese, class from stugrade_352116 " +
"ORDER BY chinese DESC";
}
else if (!bymath.equals("")) {
bygrade = "math";
sqlquery = "select stu_id, math, class from stugrade_352116 " +
"ORDER BY math DESC";
}
else if (!byenglish.equals("")) {
bygrade = "english";
sqlquery = "select stu_id, english, class from stugrade_352116 " +
"ORDER BY english DESC";
}
else if (!bycomposite.equals("")) {
bygrade = "composite";
sqlquery = "select stu_id, composite, class from stugrade_352116 " +
"ORDER BY composite DESC";
}
else {
bygrade = "total";
sqlquery = "select stu_id, total, class from stugrade_352116 " +
"ORDER BY total DESC";
}
}
}
con = getConnection("Access");
ps = con.prepareStatement(sqlquery);
rs = ps.executeQuery();
while (rs.next()) {
resultdate.add(rs.getString("stu_id"));
resultdate.add(rs.getString(bygrade));
resultdate.add(rs.getString("class"));
}
}
catch (SQLException e) {
e.printStackTrace();
}
finally {
if (rs != null)try {
rs.close();
}
catch (SQLException ignore) {}
if (ps != null)try {
ps.close();
}
catch (SQLException ignore) {}
if (con != null)try {
con.close();
}
catch (SQLException ignore) {}
finally {
releaseConnection("Access", con);
}
}
return resultdate;
}
//查询学生基本信息
public Vector stuinfQuery(int astuid, String aclass, String aname) {
Connection con = null;
ResultSet rs = null;
Statement statement = null;
String sqlquery = null;
Vector result = new Vector();
String sstuid = "";
try {
if (!aname.equals("")) {
if (!aclass.equals("全院")) {
if (aclass.equals("352111")) sqlquery =
"select * from stuinf_352111 where name ='"+aname+"'";
else if (aclass.equals("352112")) sqlquery =
"select * from stuinf_352112 where name ='"+aname+"'";
else if (aclass.equals("352113")) sqlquery =
"select * from stuinf_352113 where name ='"+aname+"'";
else if (aclass.equals("352114")) sqlquery =
"select * from stuinf_352114 where name ='"+aname+"'";
else if (aclass.equals("352115")) sqlquery =
"select * from stuinf_352115 where name ='"+aname+"'";
else if (aclass.equals("352116")) sqlquery =
"select * from stuinf_352116 where name ='"+aname+"'";
}
else sqlquery = "SELECT * FROM stuinf_352111 where name ='"+aname+
"' UNION SELECT * FROM stuinf_352112 where name ='"+aname+
"' UNION SELECT * FROM stuinf_352113 where name ='"+aname+
"' UNION SELECT * FROM stuinf_352114 where name ='"+aname+
"' UNION SELECT * FROM stuinf_352115 where name ='"+aname+
"' UNION SELECT * FROM stuinf_352116 where name ='"+aname+"'";
}
else if (!aclass.equals("")) {
if (aclass.equals("352111")) sqlquery =
"select * from stuinf_352111";
else if (aclass.equals("352112")) sqlquery =
"select * from stuinf_352112";
else if (aclass.equals("352113")) sqlquery =
"select * from stuinf_352113";
else if (aclass.equals("352114")) sqlquery =
"select * from stuinf_352114";
else if (aclass.equals("352115")) sqlquery =
"select * from stuinf_352115";
else if (aclass.equals("352116")) sqlquery =
"select * from stuinf_352116";
}else {
String stuid = String.valueOf(astuid);
if( stuid.length()<6 ) stuid = "352111";
sstuid = stuid.substring(0, 6);
if (sstuid.equals("352111"))
sqlquery = "select * from stuinf_352111 where stu_id =" + astuid;
else if (sstuid.equals("352112"))
sqlquery = "select * from stuinf_352112 where stu_id =" + astuid;
else if (sstuid.equals("352113"))
sqlquery = "select * from stuinf_352113 where stu_id =" + astuid;
else if (sstuid.equals("352114"))
sqlquery = "select * from stuinf_352114 where stu_id =" + astuid;
else if (sstuid.equals("352115"))
sqlquery = "select * from stuinf_352115 where stu_id =" + astuid;
else if (sstuid.equals("352116"))
sqlquery = "select * from stuinf_352116 where stu_id =" + astuid;
}
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?