java 选课系统_简单的JAVAWeb选课系统

最新推荐文章于 2024-04-28 23:56:33 发布

Gee Law

最新推荐文章于 2024-04-28 23:56:33 发布

阅读量1.1k

点赞数 1

文章标签： java 选课系统

本文链接：https://blog.csdn.net/weixin_42312133/article/details/114413644

版权

该系统管理员可以添加和删除学生、教师，教师可以修改自己信息、添加课程、浏览自己课程，学生可以修改自己的信息、选课、浏览全部课程。首先展示文件：然后就是一次展示代码：Guanli包中代码：package Guanli;import java.sql.Connection;import java.sql.SQLException;import java.sql.Statement;import Log...

摘要由CSDN通过智能技术生成

该系统管理员可以添加和删除学生、教师，教师可以修改自己信息、添加课程、浏览自己课程，学生可以修改自己的信息、选课、浏览全部课程。

首先展示文件：

然后就是一次展示代码：

Guanli包中代码：

package Guanli;

import java.sql.Connection;

import java.sql.SQLException;

import java.sql.Statement;

import Login.DBUtil;public classAdd {publicboolean add(String table,AddService en)

{

boolean c=false;

String sql="insert into"+table+"(username,password,power,name) values('"+en.getUsername()+"','"+en.getPassword()+"','"+en.getPower()+"','"+en.getName()+"');";

Connection conn=DBUtil.getConn();

Statement state=null;try{

state=conn.createStatement();int num=state.executeUpdate(sql);if(num!=0)

c=true;

state.close();

conn.close();

}catch(SQLException e) {//TODO Auto-generated catch block//e.printStackTrace();

}returnc;

}publicboolean add(String table,TeacherService en)

{

boolean c=false;

String sql="insert into"+table+"(gonghao,xingming,xingbie,xueyuan,zhicheng) values('"+en.getGonghao()+"','"+en.getXingming()+"','"+en.getXingbie()+"','"+en.getXueyuan()+"','"+en.getZhicheng()+"');";

Connection conn=DBUtil.getConn();

Statement state=null;try{

state=conn.createStatement();int num=state.executeUpdate(sql);if(num!=0)

c=true;

state.close();

conn.close();

}catch(SQLException e) {//TODO Auto-generated catch block//e.printStackTrace();

}returnc;

}publicboolean add(String table,StudentService en)

{

boolean c=false;

String sql="insert into"+table+"(xuehao,xingming,xingbie,banji,zhuanye) values('"+en.getXuehao()+"','"+en.getXingming()+"','"+en.getXingbie()+"','"+en.getBanji()+"','"+en.getZhuanye()+"');";

Connection conn=DBUtil.getConn();

Statement state=null;try{

state=conn.createStatement();int num=state.executeUpdate(sql);if(num!=0)

c=true;

state.close();

conn.close();

}catch(SQLException e) {//TODO Auto-generated catch block//e.printStackTrace();

}returnc;

}

package Guanli;

import java.sql.Time;

import java.text.SimpleDateFormat;

import java.util.Date;public classAddService {

String username;

String password;

String name;publicString getName() {returnname;

}public voidsetName(String name) {this.name =name;

}intpower;publicString getUsername() {returnusername;

}public voidsetUsername(String username) {this.username =username;

}publicString getPassword() {returnpassword;

}public voidsetPassword(String password) {this.password =password;

}public intgetPower() {returnpower;

}public void setPower(intpower) {this.power =power;

}

packageGuanli;importjava.awt.Desktop.Action;importjava.io.IOException;importjavax.servlet.ServletException;importjavax.servlet.annotation.WebServlet;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importLogin.Power;importLogin.Select;/*** Servlet implementation class RegisterServlet*/@WebServlet("/RegisterServlet")public class RegisterServlet extendsHttpServlet {private static final long serialVersionUID = 1L;/***@seeHttpServlet#HttpServlet()*/

publicRegisterServlet() {super();//TODO Auto-generated constructor stub

}protected void service(HttpServletRequest arg0, HttpServletResponse arg1) throwsServletException, IOException

{

Select s=newSelect();

arg0.setCharacterEncoding("utf-8");

arg1.setCharacterEncoding("utf-8");booleanflag;

String function=arg0.getParameter("method");if(function.equals("teacher"))

{

AddService as=newAddService();

Add a=newAdd();

String username;

username=arg0.getParameter("username");

as.setUsername(username);

String password;

password=arg0.getParameter("password");

as.setPassword(password);int num=1;

as.setPower(num);

TeacherService ts=newTeacherService();

String gonghao;

gonghao=arg0.getParameter("gonghao");

ts.setGonghao(gonghao);

String xingming;

xingming=arg0.getParameter("xingming");

ts.setXingming(xingming);

as.setName(xingming);

String xingbie;

xingbie=arg0.getParameter("xingbie");

ts.setXingbie(xingbie);

String xueyuan;

xueyuan=arg0.getParameter("xueyuan");

ts.setXueyuan(xueyuan);

String zhicheng;

zhicheng=arg0.getParameter("zhicheng");

ts.setZhicheng(zhicheng);

a.add("login", as);

a.add("teacher", ts);

arg0.setAttribute("message","添加成功");

arg0.getRequestDispatcher("Right.jsp").forward(arg0, arg1);

}if(function.equals("student"))

{

AddService as=newAddService();

Add a=newAdd();

String username;

username=arg0.getParameter("username");

as.setUsername(username);

String password;

password=arg0.getParameter("password");

as.setPassword(password);int num=2;

as.setPower(num);

StudentService ss=newStudentService();

String xuehao;

xuehao=arg0.getParameter("xuehao");

ss.setXuehao(xuehao);

String xingming;

xingming=arg0.getParameter("xingming");

ss.setXingming(xingming);

as.setName(xingming);

String xingbie;

xingbie=arg0.getParameter("xingbie");

ss.setXingbie(xingbie);

String banji;

banji=arg0.getParameter("banji");

ss.setBanji(banji);

String zhuanye;

zhuanye=arg0.getParameter("zhuanye");

ss.setZhuanye(zhuanye);

a.add("student", ss);

a.add("login", as);

arg0.setAttribute("message","添加成功");

arg0.getRequestDispatcher("Right.jsp").forward(arg0, arg1);

}

}/***@seeHttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)*/

protected void doGet(HttpServletRequest request, HttpServletResponse response) throwsServletException, IOException {//TODO Auto-generated method stub

response.getWriter().append("Served at: ").append(request.getContextPath());

}/***@seeHttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)*/

protected void doPost(HttpServletRequest request, HttpServletResponse response) throwsServletException, IOException {//TODO Auto-generated method stub

doGet(request, response);

}

packageGuanli;public classStudentService {

String xuehao;

String xingming;

String xingbie;

String banji;

String zhuanye;publicString getXuehao() {returnxuehao;

}public voidsetXuehao(String xuehao) {this.xuehao =xuehao;

}publicString getXingming() {returnxingming;

}public voidsetXingming(String xingming) {this.xingming =xingming;

}publicString getXingbie() {returnxingbie;

}public voidsetXingbie(String xingbie) {this.xingbie =xingbie;

}publicString getBanji() {returnbanji;

}public voidsetBanji(String banji) {this.banji =banji;

}publicString getZhuanye() {returnzhuanye;

}public voidsetZhuanye(String zhuanye) {this.zhuanye =zhuanye;

}

packageGuanli;public classTeacherService {

String gonghao;

String xingming;

String xingbie;

String xueyuan;

String zhicheng;publicString getGonghao() {returngonghao;

}public voidsetGonghao(String gonghao) {this.gonghao =gonghao;

}publicString getXingming() {returnxingming;

}public voidsetXingming(String xingming) {this.xingming =xingming;

}publicString getXingbie() {returnxingbie;

}public voidsetXingbie(String xingbie) {this.xingbie =xingbie;

}publicString getXueyuan() {returnxueyuan;

}public voidsetXueyuan(String xueyuan) {this.xueyuan =xueyuan;

}publicString getZhicheng() {returnzhicheng;

}public voidsetZhicheng(String zhicheng) {this.zhicheng =zhicheng;

}

Login包里的文件：

packageLogin;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;/*** 数据库连接工具

*@authorHu

**/

public classDBUtil {public static String db_url = "jdbc:mysql://localhost:3306/jianmintest?useSSL=false&serverTimezone=UTC&characterEncoding=UTF-8";public static String db_user = "root";public static String db_pass = "20183629";public staticConnection getConn () {

Connection conn= null;try{

Class.forName("com.mysql.jdbc.Driver");//加载驱动

conn =DriverManager.getConnection(db_url, db_user, db_pass);

}catch(Exception e) {

e.printStackTrace();

}returnconn;

}/*** 关闭连接

*@paramstate

*@paramconn*/

public static voidclose (Statement state, Connection conn) {if (state != null) {try{

state.close();

}catch(SQLException e) {

e.printStackTrace();

}

}if (conn != null) {try{

conn.close();

}catch(SQLException e) {

e.printStackTrace();

}

}public static voidclose (ResultSet rs, Statement state, Connection conn) {if (rs != null) {try{

rs.close();

}catch(SQLException e) {

e.printStackTrace();

}

}if (state != null) {try{

state.close();

}catch(SQLException e) {

e.printStackTrace();

}

}if (conn != null) {try{

conn.close();

}catch(SQLException e) {

e.printStackTrace();

}

}public static void main(String[] args) throwsSQLException {

Connection conn=getConn();

PreparedStatement pstmt= null;

ResultSet rs= null;

String sql="select * from course";

pstmt=conn.prepareStatement(sql);

rs=pstmt.executeQuery();if(rs.next()){

System.out.println("空");

}else{

System.out.println("不空");

}

packageLogin;importjava.io.IOException;importjavax.servlet.ServletException;importjavax.servlet.annotation.WebServlet;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;/*** Servlet implementation class LoginServlet*/@WebServlet("/LoginServlet")public class LoginServlet extendsHttpServlet {private static final long serialVersionUID &#

最低0.47元/天解锁文章

Gee Law

关注

1
点赞
踩
17

收藏

觉得还不错? 一键收藏
0
评论
java 选课系统_简单的JAVAWeb选课系统

该系统管理员可以添加和删除学生、教师，教师可以修改自己信息、添加课程、浏览自己课程，学生可以修改自己的信息、选课、浏览全部课程。首先展示文件：然后就是一次展示代码：Guanli包中代码：package Guanli;import java.sql.Connection;import java.sql.SQLException;import java.sql.Statement;import Log...
复制链接

扫一扫