话不多说,先上效果图 1、登录界面 学生信息管理界面 展示信息 添加信息 修改信息 3、课程信息管理界面 4、成绩信息管理界面 部分代码 登录 学生信
话不多说,先上效果图
1、登录界面
学生信息管理界面
展示信息
添加信息
修改信息
3、课程信息管理界面
4、成绩信息管理界面
部分代码
<!DOCTYPE html><html lang="en"><head> <meta charset="UTF-8"> <title>登录</title> <link rel="stylesheet" href="../bootstrap/CSS/bootstrap.min.css"></head><body> <h1 class="text-center">学生信息管理系统</h1> <div class="container"> <div class="fORM-group"> <label>用户名</label> <input type="text" class="form-control" id="username" placeholder="请输入用户名"/> </div> <div class="form-group"> <label>密码</label> <input type="passWord" class="form-control" id="password" placeholder="请输入密码"/> </div> <div class="row"> <div class="col-md-6"> <button class="btn btn-info btn-block btn-flat" id="loginBtn">登录</button> </div> <div class="col-md-6"> <button class="btn btn-info btn-block btn-flat" id="resetBtn" type="reset">重置</button> </div> </div> </div> <script src="../js/Jquery-2.1.4.min.js"></script> <script src="../bootstrap/js/bootstrap.min.js"></script> <script> $('#loginBtn').on('click',function(){ var username = $('#username').val(); var password = $('#password').val(); //alert(username+" "+password); var url = "/LoginServlet"; var d={ "username":username, "password":password }; $.ajax({ type:"post", url:url, dataType:"JSON", data:d, success:function(res){ if(res.code == 1){ window.location='/student/student.html'; }else{ alert("用户名或密码错误!"); } } }) }); </script></body></html>
package login;import database.DataBaseAccess;import java.sql.*;public class LoginAccess extends DataBaseAccess{ public static boolean checkUser(String username, String password) { Connection connection = null; PreparedStatement p = null; ResultSet resultSet = null; String sql = "select * from user where name=? and password=?"; try { connection = getConnection(); assert connection != null; p = connection.prepareStatement(sql); p.setString(1,username); p.setString(2,password); resultSet = p.executeQuery(); if(resultSet.next()) { return true; } } catch (SQLException e) { e.printStackTrace(); } finally { close(resultSet,p,connection); } return false; }}
package login;import com.alibaba.fastjson.JSONObject;import javax.servlet.annotation.WEBServlet;import javax.servlet.Http.httpservlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import java.io.IOException;import java.io.PrintWriter;@WebServlet("/LoginServlet")public class LoginServlet extends HttpServlet{ private static final long serialVersionUID = 1L; protected void doPost(HttpServletRequest res, HttpServletResponse resp) throws IOException { // 设置响应的内容编码方式为UTF-8,才能使用中文 //resp.setCharacterEncoding("UTF-8"); //resp.setContentType("text/html;charset=UTF-8"); // 从前端的请求中拿到用户名和密码 String username = res.getParameter("username"); String password = res.getParameter("password"); //System.out.println(username+" "+password); // 开始验证 JSONObject jsonObject = new JSONObject(); if(LoginAccess.checkUser(username, password)) { jsonObject.put("code",1); }else { jsonObject.put("code",0); } // 返回前端 PrintWriter printWriter = resp.getWriter(); printWriter.print(jsonObject); printWriter.close(); }}
package student;public class Student {private int id;private String name;private String major;public Student(int id, String name,String major) {this.id=id;this.name=name;this.major=major;}public int getId() {return id;}public void setId(int id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}public String getMajor() {return major;}public void setMajor(String major) {this.major = major;}public void print() {System.out.println(this.id+"\t\t"+this.name+"\t\t"+this.major);}}
package grade;import course.Course;import student.Student;public class Grade{ private String studentName; // 该成绩所对应的学生姓名 private String courseName; // 该成绩所对应的课程名称 private double grade; // 成绩 public Grade(String studentName, String courseName, double grade) { this.studentName = studentName; this.courseName = courseName; this.grade = grade; } public String getStudentName() { return studentName; } public void setStudentName(String studentName) { this.studentName = studentName; } public String getCourseName() { return courseName; } public void setCourseName(String courseName) { this.courseName = courseName; } public double getGrade() { return grade; } public void setGrade(double grade) { this.grade = grade; }}
来源地址:https://blog.csdn.net/qq_57987156/article/details/128437569
--结束END--
本文标题: HTML+JavaScript+Servlet+MySQL实现一个简单的学生信息管理系统
本文链接: https://www.lsjlt.com/news/428068.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-11
2024-05-11
2024-05-11
2024-05-11
2024-05-11
2024-05-11
2024-05-11
2024-05-11
2024-05-11
2024-05-11
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0