91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 2.1MB
    文件類型: .rar
    金幣: 2
    下載: 0 次
    發(fā)布日期: 2023-08-11
  • 語言: Java
  • 標簽: JAVA??MySQL??Swing??

資源簡介

大二時候的課設,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\baseDao.class

?????文件???????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個文件信息

評論

共有 條評論