資源簡介
大二時候的課設,JAVA鏈接MySQL實現(xiàn)的學生信息管理系統(tǒng)和學生選課管理系統(tǒng)。使用SWing實現(xiàn)GUI設計,實現(xiàn)學生和管理員兩種身份登錄,教師身份由于時間問題沒有完成。

代碼片段和文件信息
package?com.dao;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?com.model.Admin;
public?class?AdminDao?extends?baseDao?{
//管理員登錄
public?Admin?login(Admin?admin){
String?sql?=?“select?*?from?tab_admin?where?admin_name=??and?admin_password=?“;
Admin?adminRst?=?null;
try?{
PreparedStatement?stmt?=?con.prepareStatement(sql);//把sql語句傳給數(shù)據(jù)庫操作對象
stmt.setString(1?admin.getName());
stmt.setString(2?admin.getPassword());
ResultSet?rs?=?stmt.executeQuery();
if(rs.next()){
adminRst?=?new?Admin();
adminRst.setId(rs.getString(“admin_id“));
adminRst.setName(rs.getString(“admin_name“));
adminRst.setPassword(rs.getString(“admin_password“));
}
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
return?adminRst;
}
//修改密碼
public?String?editPassword(Admin?adminString?newPassword){
String?sql?=?“select?*?from?tab_admin?where?admin_id=??and?admin_password=?“;
PreparedStatement?stmt?=?null;
String?id?=?““;
try?{
stmt?=?con.prepareStatement(sql);
stmt.setString(1?admin.getId());
stmt.setString(2?admin.getPassword());
ResultSet?rs?=?stmt.executeQuery();
if(!rs.next()){
String?retString?=?“舊密碼錯誤!“;
return?retString;
}
id?=?rs.getString(“admin_id“);
}?catch?(SQLException?e1)?{
//?TODO?Auto-generated?catch?block
e1.printStackTrace();
}//把sql語句傳給數(shù)據(jù)庫操作對象
String?retString?=?“修改失敗“;
String?sqlString?=?“update?tab_admin?set?admin_password?=???where?admin_id?=??“;
try?{
stmt?=?con.prepareStatement(sqlString);
stmt.setString(1?newPassword);
stmt.setString(2?id);
int?rst?=?stmt.executeUpdate();
if(rst?>?0){
retString?=?“密碼修改成功!“;
}
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}//把sql語句傳給數(shù)據(jù)庫操作對象
return?retString;
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件??????23695??2019-12-02?13:57??SSCM\DB_SSCM\db_sscm.sql
?????文件????????313??2019-11-26?22:01??SSCM\DB_SSCM\tab_admin.txt
?????文件????????624??2019-11-26?19:29??SSCM\DB_SSCM\tab_class.txt
?????文件????????832??2019-12-01?13:23??SSCM\DB_SSCM\tab_course.txt
?????文件???????7123??2019-11-26?19:30??SSCM\DB_SSCM\tab_student.txt
?????文件???????1078??2019-11-26?14:44??SSCM\DB_SSCM\tab_teacher.txt
?????文件????????407??2019-11-26?18:36??SSCM\SSCM_java\.classpath
?????文件????????385??2019-11-26?18:33??SSCM\SSCM_java\.project
?????文件????????598??2019-11-26?18:33??SSCM\SSCM_java\.settings\org.eclipse.jdt.core.prefs
?????文件???????2517??2019-12-01?13:30??SSCM\SSCM_java\bin\com\dao\AdminDao.class
?????文件????????675??2019-12-01?13:30??SSCM\SSCM_java\bin\com\dao\ba
?????文件???????3043??2019-12-01?16:22??SSCM\SSCM_java\bin\com\dao\ClassDao.class
?????文件???????4631??2019-12-02?15:21??SSCM\SSCM_java\bin\com\dao\CourseDao.class
?????文件???????3891??2019-12-02?15:10??SSCM\SSCM_java\bin\com\dao\CourseSelectedDao.class
?????文件???????5005??2019-12-01?13:30??SSCM\SSCM_java\bin\com\dao\StudentDao.class
?????文件???????5027??2019-12-01?13:30??SSCM\SSCM_java\bin\com\dao\TeacherDao.class
?????文件???????1080??2019-12-01?13:30??SSCM\SSCM_java\bin\com\model\Admin.class
?????文件????????770??2019-12-01?13:30??SSCM\SSCM_java\bin\com\model\ClassInfo.class
?????文件???????1594??2019-12-02?13:31??SSCM\SSCM_java\bin\com\model\Course.class
?????文件????????945??2019-12-01?22:04??SSCM\SSCM_java\bin\com\model\CourseSelected.class
?????文件???????1328??2019-12-02?15:28??SSCM\SSCM_java\bin\com\model\Student.class
?????文件???????1518??2019-12-01?17:22??SSCM\SSCM_java\bin\com\model\Teacher.class
?????文件???????1664??2019-12-01?13:30??SSCM\SSCM_java\bin\com\model\UserType.class
?????文件???????1936??2019-12-01?13:30??SSCM\SSCM_java\bin\com\util\DbUtil.class
?????文件????????512??2019-12-01?13:30??SSCM\SSCM_java\bin\com\util\StringUtil.class
?????文件???????1189??2019-12-02?21:59??SSCM\SSCM_java\bin\com\view\AdminMainFrm$1.class
?????文件????????918??2019-12-02?21:59??SSCM\SSCM_java\bin\com\view\AdminMainFrm$2.class
?????文件???????1030??2019-12-02?21:59??SSCM\SSCM_java\bin\com\view\AdminMainFrm$3.class
?????文件???????1030??2019-12-02?21:59??SSCM\SSCM_java\bin\com\view\AdminMainFrm$4.class
?????文件???????1024??2019-12-02?21:59??SSCM\SSCM_java\bin\com\view\AdminMainFrm$5.class
............此處省略110個文件信息
評論
共有 條評論