今日打卡——昨日的继续练习

今日练习进度

　　三个dao类进行了更新一下（加了几个操作）

package com.web_09.dao;

import com.web_09.JDBC.JDBC;
import com.web_09.bean.User;

import java.sql.Connection;
import java.util.ArrayList;

public class Rootdao {
    //注册账号
    public static void zhuce(String username,String password) throws Exception {
        Connection conn = null;
        conn = JDBC.getConnection();
        String sql = "insert into systemuser(username,userpassword)values(?,?)";
        JDBC.cudsql(sql,username,password);
    }
    //用户登录
    public static int login(User user){
        ArrayList<User>arrayList = JDBC.retrieve(user);
        System.out.println(arrayList);
        if(arrayList.size()==1){
            return 1;
        }else return 0;
    }
    //修改用户密码
    public static void updatepd(User user,String uname){
        Connection conn = null;
        conn = JDBC.getConnection();
        String sql = "update systemuser set username = ?,userpassword = ? where username = ?";
        JDBC.cudsql(sql,user,uname);
    }
}

package com.web_09.dao;

import com.web_09.JDBC.JDBC;
import com.web_09.bean.Course;
import com.web_09.bean.Student;


import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class Studao {

    //填写学生用户信息
    public static void register(Student stu){
        Connection conn = null;
        conn = JDBC.getConnection();
        String sql = "insert into student(stuame,stuage,stuno,stuclass,stumajor)values(?,?,?,?,?)";
        JDBC.cudsql(sql,stu.getStuName(),stu.getStuAge(),stu.getStuNo(),stu.getStuClass(),stu.getStuMajor());
    }

    //修改学生信息
    public static void upStu(Student stu,String sno){
        Connection conn = null;
        conn = JDBC.getConnection();
        String sql = "update student set stuname = ?,stuage = ?,stuno = ?,stuclass = ?,stumajor = ? where stuno = ?";
        JDBC.cudsql(sql,stu.getStuName(),stu.getStuAge(),stu.getStuNo(),stu.getStuClass(),stu.getStuMajor(),sno);
    }
    //浏览课程信息
    public static ArrayList<Course> getCourse(){
        ArrayList<Course>arrayList = new ArrayList<>();
        PreparedStatement pre = null;
        Connection conn = JDBC.getConnection();
        ResultSet resultSet = null;
        String sql = "select * from course";

        try {
            pre = conn.prepareStatement(sql);
            resultSet = pre.executeQuery();
            System.out.println(123);
            Course course1 = null;
            while (resultSet.next()){
                String coursename = resultSet.getString("coursename");
                String courseno = resultSet.getString("courseno");
                String course_tacher = resultSet.getString("course_teacher");
                String stunum = resultSet.getString("stunum");
                String courseaddress = resultSet.getString("courseaddress");
                int num = Integer.parseInt(stunum);
                course1 = new Course(coursename,courseno,course_tacher,num,courseaddress);
                System.out.println(course1);
                arrayList.add(course1);
                System.out.println(arrayList);
            }
            System.out.println("获取课程信息");
        } catch (SQLException e) {
            System.out.println("获取课程信息失败");
        }finally {
            JDBC.close2(conn,pre,resultSet);
        }
        return arrayList;
    }
    //选课

}

package com.web_09.dao;

import com.web_09.JDBC.JDBC;
import com.web_09.bean.Course;
import com.web_09.bean.Teacher;

import java.sql.Connection;

public class Teadao {

    //填写教师用户信息
    public static void register(Teacher tea){
        Connection conn = null;
        conn = JDBC.getConnection();
        String sql = "insert into teacher(teaname,teano,teaposition,teage)values(?,?,?,?)";
        JDBC.cudsql(sql,tea.getTeaName(),tea.getTeaNo(),tea.getTeaPosition(),tea.getTeaAge());
    }
    //添加课程信息
    public static void addCourse(Course course){
        Connection conn = null;
        conn = JDBC.getConnection();
        String sql = "insert into course(coursename,courseno,course_teacher,stunum,courseaddress)values(?,?,?,?,?)";
        JDBC.cudsql(sql,course.getcName(),course.getcNo(),course.getcTeacher(),course.getcNum(),course.getcStress());
    }
    //修改教师信息
    public static void updateTea(Teacher tea,String tno){
        Connection conn = null;
        conn = JDBC.getConnection();
        String sql = "update teacher set teaname = ?,teano = ?,teaposition = ?,teage = ? where teano = ?";
        JDBC.cudsql(sql,tea.getTeaName(),tea.getTeaNo(),tea.getTeaPosition(),tea.getTeaAge(),tno);
        System.out.println(123);
    }
}

servlet也更新了一下

package com.web_09.servlet;

import com.web_09.bean.Course;
import com.web_09.bean.Student;
import com.web_09.bean.User;
import com.web_09.dao.Rootdao;
import com.web_09.dao.Studao;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.IOException;
import java.io.UnsupportedEncodingException;
import java.util.ArrayList;



public class StuServlet extends HttpServlet {


    @Override
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        String method = req.getParameter("method");
        if(method.equals("updatepd")){
            updatepd(req,resp);
        }else if(method.equals("retrieveCourse")){
            retrieveCourse(req,resp);
        }else if(method.equals("selectCourse")){
            selectCourse(req,resp);
        }else if(method.equals("quitCourse")){
            quitCourse(req,resp);
        }else if(method.equals("register")){
            register(req,resp);
        }else if(method.equals("updateStu")){
            updateStu(req,resp);
        }else if(method.equals("lookCourse")){
            lookCourse(req,resp);
        }
    }

    private void lookCourse(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException {
        req.setCharacterEncoding("utf-8");
        ArrayList<Course>arrayList = new ArrayList<>();
        arrayList = Studao.getCourse();
        System.out.println(arrayList);
        req.setAttribute("course",arrayList);
        req.getRequestDispatcher("courseshow.jsp").forward(req,resp);
    }

    private void updateStu(HttpServletRequest req, HttpServletResponse resp) throws UnsupportedEncodingException {
        req.setCharacterEncoding("utf-8");
        String stuno = req.getParameter("stuno");
        String stuname = req.getParameter("stuname");
        String stuage = req.getParameter("stuage");
        String stumajor = req.getParameter("stumajor");
        String stuclass = req.getParameter("stuclass");
        int age = Integer.parseInt(stuage);
        Student student = new Student(stuname,age,stuno,stumajor,stuclass);
        Studao.upStu(student,stuno);
    }

    private void register(HttpServletRequest req, HttpServletResponse resp) throws UnsupportedEncodingException {
        req.setCharacterEncoding("utf-8");
        String stuName = req.getParameter("stuName");
        String stuClass = req.getParameter("stuClass");
        String stuAge = req.getParameter("stuAge");
        String stuMajor = req.getParameter("stuMajor");
        String stuNo = req.getParameter("stuNo");
        int age = Integer.parseInt(stuAge);
        System.out.println("姓名："+stuName+"\n"+"班级："+stuClass+"\n"+"学号："+stuNo+"\n"+"专业："+stuMajor+"\n"+"年龄："+stuAge);
        Student student = new Student(stuName,age,stuNo,stuMajor,stuClass);
        Studao.register(student);
        System.out.println("信息登记成功");
    }

    private void quitCourse(HttpServletRequest req, HttpServletResponse resp) {

    }

    private void selectCourse(HttpServletRequest req, HttpServletResponse resp) {

    }

    private void retrieveCourse(HttpServletRequest req, HttpServletResponse resp) {

    }

    private void updatepd(HttpServletRequest req, HttpServletResponse resp) throws UnsupportedEncodingException {
        req.setCharacterEncoding("utf-8");
        String username = req.getParameter("username");
        String password = req.getParameter("password");
        User user = new User(username,password);
        Rootdao.updatepd(user,username);
    }


}

package com.web_09.servlet;

import com.web_09.JDBC.JDBC;
import com.web_09.bean.Course;
import com.web_09.bean.Teacher;
import com.web_09.bean.User;
import com.web_09.dao.Rootdao;
import com.web_09.dao.Teadao;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.IOException;
import java.io.UnsupportedEncodingException;

public class TeaServlet extends HttpServlet {
    @Override
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        String method = req.getParameter("method");
        System.out.println(method);
        if(method.equals("updatepd")){
            updatepd(req,resp);
        }else if(method.equals("retrieve")){
            retrieve(req,resp);
        }else if(method.equals("register")){
            register(req,resp);
        }else if(method.equals("addcourse")){
            addcourse(req,resp);
        }else if(method.equals("updateTea")){
            updateTea(req,resp);
        }
    }

    private void updateTea(HttpServletRequest req, HttpServletResponse resp) throws UnsupportedEncodingException {
        req.setCharacterEncoding("utf-8");
        String tno = req.getParameter("tno");
        String tname = req.getParameter("tname");
        String tposition = req.getParameter("tposition");
        String tage = req.getParameter("tage");
        int age = Integer.parseInt(tage);
        Teacher teacher = new Teacher(tname,tno,tposition,age);
        System.out.println(teacher);
        Teadao.updateTea(teacher,tno);
    }

    private void addcourse(HttpServletRequest req, HttpServletResponse resp) throws UnsupportedEncodingException {
        req.setCharacterEncoding("utf-8");
        String cname = req.getParameter("cname");
        String cno = req.getParameter("cno");
        String ctea = req.getParameter("ctea");
        String cnum = req.getParameter("cnum");
        String caddress = req.getParameter("caddress");
        int stunum = Integer.parseInt(cnum);
        Course course = new Course(cname,cno,ctea,stunum,caddress);
        Teadao.addCourse(course);
        System.out.println("课程信息添加成功");
    }

    private void retrieve(HttpServletRequest req, HttpServletResponse resp) {

    }

    private void register(HttpServletRequest req, HttpServletResponse resp) throws UnsupportedEncodingException {
        req.setCharacterEncoding("utf-8");
        String teaName = req.getParameter("teaName");
        String teaNo = req.getParameter("teaNo");
        String teaPosition = req.getParameter("teaPosition");
        String teaAge = req.getParameter("teaAge");
        int age = Integer.parseInt(teaAge);
        System.out.println("教师姓名："+teaName+"\n"+"教师工号："+teaNo+"\n"+"教师职位："+teaPosition+"\n"+"教师年龄："+age);
        Teacher teacher = new Teacher(teaName,teaNo,teaPosition,age);
        Teadao.register(teacher);
        System.out.println("信息登记成功");
    }

    private void updatepd(HttpServletRequest req, HttpServletResponse resp) throws UnsupportedEncodingException {
        req.setCharacterEncoding("utf-8");
        String username = req.getParameter("username");
        String password = req.getParameter("password");
        User user = new User(username,password);
        Rootdao.updatepd(user,username);
    }


}

package com.web_09.servlet;

import com.web_09.bean.User;
import com.web_09.dao.Rootdao;
import com.web_09.dao.Studao;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.IOException;
import java.io.UnsupportedEncodingException;

public class UserServlet extends HttpServlet {
    @Override
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        String method = req.getParameter("method");
        if(method.equals("zhuce")){
            try {
                zhuce(req,resp);
            } catch (Exception e) {
                e.printStackTrace();
            }
        }else if(method.equals("login")){
            login(req,resp);
        }else if(method.equals("resetpd")){
            resetpd(req,resp);
        }else if(method.equals("deleteUser")){
            deleteUser(req,resp);
        }
    }

    private void deleteUser(HttpServletRequest req, HttpServletResponse resp) {

    }

    private void resetpd(HttpServletRequest req, HttpServletResponse resp) {

    }

    private void login(HttpServletRequest req, HttpServletResponse resp) throws IOException {
        req.setCharacterEncoding("utf-8");
        String username = req.getParameter("username");
        String pwd = req.getParameter("pwd");
        String identy = req.getParameter("identy");
        System.out.println("用户名："+username+"\n"+"密码："+pwd);
        User user = new User(username,pwd);
        int flag = Rootdao.login(user);
        if(flag == 1 && identy.equals("学生")){
            resp.sendRedirect("stumenu.html");
        }else if(flag == 1 && identy.equals("教师")){
            resp.sendRedirect("teamenu.html");
        }else {
            resp.sendRedirect("login.html");
        }
    }

    private void zhuce(HttpServletRequest req, HttpServletResponse resp) throws Exception {
        req.setCharacterEncoding("utf-8");
        String username = req.getParameter("username");
        String pwd = req.getParameter("pwd");
        String identy = req.getParameter("identy");
        System.out.println("用户名："+username+"\n"+"密码："+pwd+"\n"+"用户身份："+identy);
        Rootdao.zhuce(username,pwd);
        System.out.println("注册成功");
        if(identy.equals("教师")){
            resp.sendRedirect("registerTea.html");
        }else if(identy.equals("学生")){
            resp.sendRedirect("registerStu.html");
        }
    }
}

新增html页面和jsp页面

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>课程添加</title>
</head>
<body>
    <form action="http://localhost:8080/web_09/teaServlet?method=addcourse" method="post">
        <table align="center">
            <tr>
                <th>添加课程信息</th>
            </tr>
            <tr>
                <td>课程名称</td>
                <td><input type="text" name="cname"></td>
            </tr>
            <tr>
                <td>课程编号</td>
                <td><input type="text" name="cno"></td>
            </tr>
            <tr>
                <td>任课教师</td>
                <td><input type="text" name="ctea"></td>
            </tr>
            <tr>
                <td>课程容量</td>
                <td><input type="text" name="cnum"></td>
            </tr>
            <tr>
                <td>上课地址</td>
                <td><input type="text" name="caddress"></td>
            </tr>
            <tr>
                <td><input type="submit" value="提交"></td>
                <td><input type="reset" value="重置"></td>
            </tr>
        </table>
    </form>
</body>
</html>

<%@ page import="java.util.ArrayList" %>
<%@ page import="com.web_09.bean.Course" %><%--
  Created by IntelliJ IDEA.
  User: dell
  Date: 2022/3/17
  Time: 21:11
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>课程信息展示</title>
</head>
<body>
    <table>
        <tr>
            <th>课程名称</th>
            <th>课程编号</th>
            <th>任课教师</th>
            <th>最大选课人数</th>
        </tr>
<%
    ArrayList<Course> arrayList = (ArrayList<Course>) request.getAttribute("course");
    for(Course course:arrayList){
%>
        <tr>
            <td><%=course.getcName()%> </td>
            <td><%=course.getcNo()%></td>
            <td><%=course.getcTeacher()%></td>
            <td><%=course.getcNum()%></td>
        </tr>
        <%
            }
        %>
    </table>
</body>
</html>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
<form action="http://localhost:8080/web_09/stuServlet?method=lookCourse" method="post">
    <input type="submit" value="查询">
</form>
</body>
</html>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>修改密码</title>
</head>
<body>
<form action="http://localhost:3306/web_09/stuServlet?method=updatepd" method="post">
    <table>
        <tr>
            <td>请输入用户名：</td>
            <td><input type="text" name="username"></td>
        </tr>
        <tr>
            <td>请输入新密码：</td>
            <td><input type="password" name="password"></td>
        </tr>
    </table>
</form>
</body>
</html>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>修改密码</title>
</head>
<body>
<form action="http://localhost:3306/web_09/teaServlet?method=updatepd" method="post">
    <table>
        <tr>
            <td>请输入用户名：</td>
            <td><input type="text" name="username"></td>
        </tr>
        <tr>
            <td>请输入新密码：</td>
            <td><input type="password" name="password"></td>
        </tr>
    </table>
</form>
</body>
</html>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>教师信息修改</title>
</head>
<body>
<form action="http://localhost:8080/web_09/teaServlet?method=updateTea" method="post">
    <table align="center" border="1">
        <tr>
            <td>请输入教师工号</td>
            <td><input type="text" name="tno"></td>
        </tr>
        <tr>
            <td>请输入新的教师姓名</td>
            <td><input type="text" name="tname"></td>
        </tr>
        <tr>
            <td>请输入新的教师职位</td>
            <td><input type="text" name="tposition"></td>
        </tr>
        <tr>
            <td>请输入新的教师年龄</td>
            <td><input type="text" name="tage"></td>
        </tr>
        <tr>
            <td><input type="submit" value="提交"></td>
            <td><input type="reset" value="重置"></td>
        </tr>
    </table>
</form>
</body>
</html>

今天就写了这么多，明天继续吧。

posted @ 2022-03-17 23:16 几人著眼到青衫阅读(44) 评论(0) 收藏举报

刷新页面返回顶部

软件工程

今日打卡——昨日的继续练习

公告