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

  • 大小: 4.32MB
    文件類型: .zip
    金幣: 2
    下載: 0 次
    發(fā)布日期: 2023-09-17
  • 語言: Java
  • 標簽: Java??IDEA??JavaWeb??JSP??

資源簡介

用IDEA開發(fā)的JavaWeb簡易作業(yè)管理系統(tǒng),使用MySql數(shù)據(jù)庫,內(nèi)含建表語句。
功能實現(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.xml
?????目錄???????????0??2020-03-10?22:49??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\.idea\codestyles\
?????文件?????????153??2020-03-10?20:44??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\.idea\codestyles\codestyleConfig.xml
?????目錄???????????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.xml
?????文件?????????276??2020-03-10?20:44??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\.idea\misc.xml
?????文件?????????291??2020-03-10?20:44??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\.idea\modules.xml
?????文件???????10652??2020-03-10?22:41??JavaWeb-HomeworkManager\JavaEE-HomeworkManager\.idea\workspace.xml
?????文件????????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個文件信息

評論

共有 條評論