简陋的学生作业管理系统
基本功能有:老师:添加学生,添加作业,查询作业
学生:根据已有作业进行提交
比较简陋,没有设置权限上图是主界面,可点击相应连接进入对应界面
学生提交作业界面
作业查询界面
老师添加作业界面
老师添加学生界面
代码主要分为实体类,jdbc,servlet和jsp几部分,忽略test部分
主要展示一下jdbc,servlet和jsp部分
jdbc部分与MySQL连接,并传输数据:
学习jdbc可参照:https://www.runoob.com/w3cnote/jdbc-use-guide.html
public class Homeworkjdbc {
public static void addHomework(Homework h){
String url="jdbc:mysql://127.0.0.1:3306/school?useUnicode=true&characterEncoding=utf-8&useSSL=false";
String driverName="com.mysql.jdbc.Driver";
String insert_sql = "insert into school.s_homework (title,content,create_time,update_time) "
+ "VALUES (?,?,?,?)";
try(Connection connection= DriverManager.getConnection(url,"root","123456")){
PreparedStatement stat = connection.prepareStatement(insert_sql);
stat.setString(1, h.getTitle());
stat.setString(2, h.getContent());
stat.setObject(3, h.getCreateTime());
stat.setObject(4, h.getUpdateTime());
int i = stat.executeUpdate();
}catch (SQLException e) {
e.printStackTrace();
}
}
}在这里插入代码片
public class StudentHomeworkjdbc {
public static void addStudentHomework(Long studentid,Long homeworkid){
String url="jdbc:mysql://127.0.0.1:3306/school?useUnicode=true&characterEncoding=utf-8&useSSL=false";
String driverName="com.mysql.jdbc.Driver";
String selects_sql="select * from school.s_student where id='"+studentid+"'";
String selecth_sql="select * from school.s_homework where id='"+homeworkid+"'";
boolean fs=false;
boolean fh=false;
StudentHomework sh=new StudentHomework();
Student s=new Student();
Homework h=new Homework();
try{
Connection connection= DriverManager.getConnection(url,"root","123456");
Statement statement=connection.createStatement();
ResultSet resultSet=statement.executeQuery(selects_sql);
while(resultSet.next()){
if(resultSet.getLong("id")==studentid){
s.setId(resultSet.getLong("id"));
s.setName(resultSet.getString("name"));
fs=true;
}
}
ResultSet resultSet2=statement.executeQuery