資源簡介
用IDEA開發(fā)的JavaWeb簡易作業(yè)管理系統(tǒng),使用MySql數(shù)據(jù)庫,內(nèi)含建表語句。
功能實現(xiàn)如下:
老師:添加作業(yè),添加學(xué)生,查看作業(yè)情況
學(xué)生:提交作業(yè)
功能實現(xiàn)如下:
老師:添加作業(yè),添加學(xué)生,查看作業(yè)情況
學(xué)生:提交作業(yè)

代碼片段和文件信息
package?com.java.code.Jdbc;
import?com.java.code.Model.Homework;
import?com.java.code.Model.Student;
import?com.java.code.Model.StudentHomework;
import?java.sql.*;
import?java.util.ArrayList;
import?java.util.List;
public?class?StudentHomeworkJdbc?{
????public?static?void?main(String[]?args)?{
????????String?a?=“1“;
????????List?list?=?selectAll(a);
????????for?(StudentHomework?sthw?:?list){
????????????System.out.println(sthw.gethwId());
????????}
????????Homework?hw?=?showHomeworkDetails(a);
????????System.out.println(hw.gethwtitle());
????}
????private?static?String?url?=?“jdbc:mysql://127.0.0.1:3306/school?serverTimezone=Asia/Shanghai“;
????private?static?String?driverName?=?“com.mysql.cj.jdbc.Driver“;
????/**
?????*?從student_homework表讀取指定作業(yè)id?的所有記錄,即某次作業(yè)的所有提交記錄
?????*?@return?返回結(jié)果list
?????*/
????public?static?List?selectAll(String?hw_id)?{
????????try?{
????????????Class.forName(driverName);
????????}?catch?(ClassNotFoundException?e)?{
????????????e.printStackTrace();
????????}
????????String?sqlString?=?“SELECT?*?FROM?student_homework?where?hw_id=“+hw_id;
????????List?list?=?new?ArrayList<>();
????????try?(Connection?connection?=?DriverManager.getConnection(url?“root“?“12345ysp“))?{
????????????try?(Statement?statement?=?connection.createStatement())?{
????????????????try?(ResultSet?resultSet?=?statement.executeQuery(sqlString))?{
????????????????????//獲取執(zhí)行結(jié)果
????????????????????while?(resultSet.next())?{
????????????????????????StudentHomework?sh?=?new?StudentHomework();
????????????????????????sh.setsthwId(resultSet.getLong(“st_hw_id“));
????????????????????????sh.setstId(resultSet.getLong(“st_id“));
????????????????????????sh.sethwId(resultSet.getLong(“hw_id“));
????????????????????????sh.sethwtitle(resultSet.getString(“hw_title“));
????????????????????????sh.sethwContent(resultSet.getString(“hw_content“));
????????????????????????sh.setsubmitContent(resultSet.getString(“submit_content“));
????????????????????????sh.setsthwCreateTime(resultSet.getTimestamp(“st_hw_create_time“));
????????????????????????list.add(sh);
????????????????????}
????????????????}
????????????}
????????}?catch?(SQLException?e)?{
????????????e.printStackTrace();
????????}
????????return?list;
????}
????/**
?????*?向homework表添加作業(yè)記錄
?????*?@param?homework??將要添加的homework
?????*?@return?true=>成功否則失敗
?????*/
????public?static?boolean?addHomework(Homework?homework){
????????try?{
????????????Class.forName(driverName);
????????}?catch?(ClassNotFoundException?e)?{
????????????e.printStackTrace();
????????}
????????String?sqlString?=?“insert?into?homework?(hw_idhw_titlehw_contenthw_create_time)?values(????)“;
????????int?resultSet?=?0;
????????try?(Connection?connection?=?DriverManager.getConnection(url?“root“?“12345ysp“))?{
????????????try?(PreparedStatement?ps?=?connection.prepareStatement(sqlString))?{
?????????
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2020-03-10?22:49??JavaWeb-HomeworkManager\
?????目錄???????????0??2020-03-10?22:49??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\
?????目錄???????????0??2020-03-10?22:49??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\.idea\
?????目錄???????????0??2020-03-10?22:49??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\.idea\artifacts\
?????文件?????????563??2020-03-10?20:44??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\.idea\artifacts\JavaEE_HomeworkManager_war_exploded.xm
?????目錄???????????0??2020-03-10?22:49??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\.idea\codest
?????文件?????????153??2020-03-10?20:44??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\.idea\codest
?????目錄???????????0??2020-03-10?22:49??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\.idea\libraries\
?????文件?????????290??2020-03-10?20:46??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\.idea\libraries\lib.xm
?????文件?????????276??2020-03-10?20:44??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\.idea\misc.xm
?????文件?????????291??2020-03-10?20:44??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\.idea\modules.xm
?????文件???????10652??2020-03-10?22:41??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\.idea\workspace.xm
?????文件????????1000??2020-03-10?20:46??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\JavaEE-HomeworkManager.iml
?????目錄???????????0??2020-03-10?22:49??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\out\
?????目錄???????????0??2020-03-10?22:49??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\out\artifacts\
?????目錄???????????0??2020-03-10?22:49??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\out\artifacts\JavaEE_HomeworkManager_war_exploded\
?????目錄???????????0??2020-03-10?22:49??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\out\artifacts\JavaEE_HomeworkManager_war_exploded\WEB-INF\
?????目錄???????????0??2020-03-10?22:49??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\out\artifacts\JavaEE_HomeworkManager_war_exploded\WEB-INF\classes\
?????目錄???????????0??2020-03-10?22:49??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\out\artifacts\JavaEE_HomeworkManager_war_exploded\WEB-INF\classes\com\
?????目錄???????????0??2020-03-10?22:49??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\out\artifacts\JavaEE_HomeworkManager_war_exploded\WEB-INF\classes\com\java\
?????目錄???????????0??2020-03-10?22:49??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\out\artifacts\JavaEE_HomeworkManager_war_exploded\WEB-INF\classes\com\java\code\
?????目錄???????????0??2020-03-10?22:49??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\out\artifacts\JavaEE_HomeworkManager_war_exploded\WEB-INF\classes\com\java\code\Jdbc\
?????文件????????9138??2020-03-10?22:34??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\out\artifacts\JavaEE_HomeworkManager_war_exploded\WEB-INF\classes\com\java\code\Jdbc\StudentHomeworkJdbc.class
?????目錄???????????0??2020-03-10?22:49??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\out\artifacts\JavaEE_HomeworkManager_war_exploded\WEB-INF\classes\com\java\code\Model\
?????文件????????1283??2020-03-10?20:46??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\out\artifacts\JavaEE_HomeworkManager_war_exploded\WEB-INF\classes\com\java\code\Model\Homework.class
?????文件????????1083??2020-03-10?20:46??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\out\artifacts\JavaEE_HomeworkManager_war_exploded\WEB-INF\classes\com\java\code\Model\Student.class
?????文件????????1852??2020-03-10?20:46??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\out\artifacts\JavaEE_HomeworkManager_war_exploded\WEB-INF\classes\com\java\code\Model\StudentHomework.class
?????目錄???????????0??2020-03-10?22:49??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\out\artifacts\JavaEE_HomeworkManager_war_exploded\WEB-INF\classes\com\java\code\Servlet\
?????文件????????2088??2020-03-10?20:46??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\out\artifacts\JavaEE_HomeworkManager_war_exploded\WEB-INF\classes\com\java\code\Servlet\AddHomeworkServlet.class
?????文件????????2020??2020-03-10?20:46??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\out\artifacts\JavaEE_HomeworkManager_war_exploded\WEB-INF\classes\com\java\code\Servlet\AddStudentServlet.class
?????文件????????1598??2020-03-10?20:46??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\out\artifacts\JavaEE_HomeworkManager_war_exploded\WEB-INF\classes\com\java\code\Servlet\QueryStudentHomeworkServlet.class
............此處省略67個文件信息
評論
共有 條評論