java web石家庄铁道大学课程管理系统

package kecheng

Kc.java

package kecheng;

public class Kc {
    private int id;
    private String classname;
    private String teachername;
    private String place;
    public String getClassname() {
        return classname;
    }
    public void setClassname(String classname) {
        this.classname = classname;
    }
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getTeachername() {
        return teachername;
    }
    public void setTeachername(String teachername) {
        this.teachername = teachername;
    }
    public String getPlace() {
        return place;
    }
    public void setPlace(String place) {
        this.place = place;
    }

}

Mysqlopear.java

package kecheng;

import java.sql.*;


public class Mysqlopear {
    private String driverStr="com.mysql.cj.jdbc.Driver";
    private String connStr="jdbc:mysql://127.0.0.1:3306/db_database17?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT";
    private String dbusername="root";
    private String dbpassword="123456";
    private Connection conn=null;
    private Statement stmt=null;
    public Connection getCon() {
        try {
            Class.forName(driverStr);
            conn=DriverManager.getConnection(connStr, dbusername, dbpassword);
            return conn;
        } catch (Exception e) {
            System.out.println("数据连接失败！");
            System.out.println(e.getMessage());
            return null;
        }       
    }
    public int executeUpdate(String s) {
        int result=0;
        System.out.println("更新语句："+s+"
");
        try {
            result=stmt.executeUpdate(s);            
        }catch(Exception e) {
            System.out.println("执行更新错误！");
        }
        return result;
    }
    
    //查询操作
    public ResultSet executeQuery(String s) {
        ResultSet rs=null;
        System.out.println("查询语句:"+s+"
");
        try {
            rs=stmt.executeQuery(s);
            while(rs.next()) {
                System.out.println("课程名称："+rs.getString(1)+"  "+"教师名称："+rs.getString(2)+"  "+"教室位置："+rs.getString(3));
            }
        }catch(Exception e) {
            System.out.println("执行查询错误！");
        }
        return rs;
    }
    public void close() {
        try {
            stmt.close();
            conn.close();
        }catch(Exception e) {           
        }
    }
    
}

package service

Kcservice.java

package service;

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


public class Kcservice {
    private Connection conn;
    private PreparedStatement pstmt;
    public Kcservice() {
        conn=new kecheng.Mysqlopear().getCon();
    }
    
    //录入部分
        public boolean addStu(Kc kc){
            try {
                pstmt=conn.prepareStatement("insert into kc"
            +"(classname,teachername,place)"
                        +"values(?,?,?)");
                pstmt.setString(1, kc.getClassname());
                pstmt.setString(2, kc.getTeachername());
                pstmt.setString(3, kc.getPlace());
                pstmt.executeUpdate();
                return true;
            } catch (SQLException e) {
                e.printStackTrace();
                return false;
            }
        }
        public Kc queryStuByID(int id) {
            try {
                pstmt=conn.prepareStatement("select * from kc where id=?");
                pstmt.setInt(1, id);
                ResultSet rs=pstmt.executeQuery();
                if(rs.next()) {
                    Kc stu=new Kc();
                    stu.setId(rs.getInt(1));
                    stu.setClassname(rs.getString(2));
                    stu.setTeachername(rs.getString(3));
                    stu.setPlace(rs.getString(4));
                    return stu;
                }
                return null;
            }
            catch(SQLException e) {
                e.printStackTrace();
                return null;
            }
        }
        public List queryAllStu() {
            List stus=new ArrayList();
            try {
                pstmt=conn.prepareStatement("select * from kc");
                ResultSet rs=pstmt.executeQuery();
                while(rs.next()) {
                    Kc stu=new Kc();
                    stu.setId(rs.getInt(1));
                    stu.setClassname(rs.getString(2));
                    stu.setTeachername(rs.getString(3));
                    stu.setPlace(rs.getString(4));
                    stus.add(stu);                    
                }
                return stus;
            }
            catch(SQLException e) {
                e.printStackTrace();
                return null;
            }
        }
        public boolean updateStu(Kc kc) {
            try {
                    pstmt=conn.prepareStatement("update kc set classname=?,teachername=?,place=? where id=? ");
                    pstmt.setString(1, kc.getClassname());
                    pstmt.setString(2, kc.getTeachername());
                    pstmt.setString(3, kc.getPlace());
                    pstmt.setInt(4, kc.getId());
                    pstmt.executeUpdate();
                return true;
            }catch(Exception e) {
                e.printStackTrace();
                return false;
            }
        }
        //删除部分
        public boolean deleteStu(int id) {
            try {
                pstmt=conn.prepareStatement("delete from kc where id=?");
                pstmt.setInt(1, id);
                pstmt.executeUpdate();
                return true;
            }catch(Exception e) {
                e.printStackTrace();
                return false;
            }
        }

}

框架：main.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<frameset rows="18%,*">  
<frame src="title.jsp">
<frameset cols="10%,*">
<frame src="main_left.jsp">
<frame src="main_right.jsp" name="main_right">
</frameset>
<body>

</body>
</html>

左侧菜单：main_left.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<a href="tianjia.jsp" target="main_right">录入学生信息</a><br/>
<a href="chaxun.jsp" target="main_right">查看学生信息</a><br/>
<a href="xiugai.jsp" target="main_right">修改学生信息</a><br/>
<a href="shanchu.jsp" target="main_right">删除学生信息</a><br/>
</body>
</html>

右侧界面：main_right.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>

</body>
</html>

标题：title.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>石家庄铁道大学课程信息管理系统</title>

</head>
<body>
<center>
<h1>石家庄铁道大学课程信息管理系统</h1>
</center>
</body>
</html>

添加新课程：tianjia.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>添加新课程页</title>
</head>
<body>
<h1 style=color:red>添加新课程</h1>
<form  action="tj_result.jsp"method="post">
<table>

<tr>
<td>课程名称:</td>
<td><input type="text"name="classname"></td>
</tr>
<tr>
<td>任课教师:</td>
<td><input type="text"name="teachername"></td>
</tr>
<tr>
<td>上课地点:</td>
<td><input type="text"name="place"></td>
</tr>
</table>
<br>
<input type="submit" value="保存">
</form>
</body>
</html>

添加处理：tj_result.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>添加处理</title>
</head>
<body>
<% request.setCharacterEncoding("utf-8"); %>
<jsp:useBean id="kc" class="kecheng.Kc" ></jsp:useBean>
<jsp:useBean id="kcservice" class="service.Kcservice"></jsp:useBean>
<jsp:setProperty property="*" name="kc"/>
<%
if(!(kc.getTeachername().equals("王建民")||kc.getTeachername().equals("刘丹")
        ||kc.getTeachername().equals("刘立嘉")||kc.getTeachername().equals("王辉")
        ||kc.getTeachername().equals("杨子光"))){
    out.print("<script language='javaScript'> alert('教师姓名非法');</script>");
    response.setHeader("refresh", "0;url=tianjia.jsp");
}
else{
if(kcservice.addStu(kc))
    out.print("success");
else
    out.print("error");}
%>
</body>
</html>

删除：shanchu.jsp

<%@page import="kecheng.Kc"%>
<%@page import="java.util.Iterator"%>
<%@page import="java.util.List"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>删除课程</title>
</head>
<body>
<jsp:useBean id="stuSer" class="service.Kcservice"></jsp:useBean>
<%
List stus=stuSer.queryAllStu();
//out.print(stus.size());
Iterator iter=stus.iterator();
%>
<table>
<tr> <td>ID  </td> <td>课程姓名    </td> <td>教师姓名</td><td>上课地点</td>  </tr>

<%
int i=0;
while(iter.hasNext())
{
    Kc kc=(Kc)iter.next();
    %>
    <tr <%if(i%2==0){ %>bgcolor="#F0F8FF"<%} %>>
    <td> <%=kc.getId() %></td>
    <td> <%=kc.getClassname() %></td>
    <td> <%=kc.getTeachername()%></td>
    <td> <%=kc.getPlace()%></td>
    <td> <a href="sc_result.jsp?id=<%=kc.getId() %>">删除</a></td>
    </tr>
    <%
    i++;
}
%>
</table>
</body>
</html>

删除处理：sc_result.jsp

<%@page import="kecheng.Kc"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>删除处理</title>
</head>
<body>
<jsp:useBean id="stuSer" class="service.Kcservice"></jsp:useBean>
<%
int id=Integer.parseInt(request.getParameter("id"));
Kc stu=stuSer.queryStuByID(id);
if(stuSer.deleteStu(id))
    out.print("success");
else
    out.print("false");
%>
</body>
</html>

修改：xuigai.jsp

<%@page import="kecheng.Kc"%>
<%@page import="java.util.Iterator"%>
<%@page import="java.util.List"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>修改</title>
</head>
<body>
<jsp:useBean id="stuSer" class="service.Kcservice"></jsp:useBean>
<%
List stus=stuSer.queryAllStu();
Iterator iter=stus.iterator();
%>
<table>
<tr> <td>ID  </td> <td>课程姓名    </td> <td>教师姓名</td><td>上课地点</td>  </tr>

<%
int i=0;
while(iter.hasNext())
{
    Kc kc=(Kc)iter.next();
    %>
    <tr <%if(i%2==0){ %>bgcolor="#F0F8FF"<%} %>>
    <td> <%=kc.getId() %></td>
    <td> <%=kc.getClassname() %></td>
    <td> <%=kc.getTeachername()%></td>
    <td> <%=kc.getPlace()%></td>
    <td> <a href="修改处理.jsp?id=<%=kc.getId() %>">修改</a></td>
    </tr>
    <%
    i++;
}
%>
</table>
</body>
</html>

修改处理：xg_result.jsp

<%@page import="kecheng.Kc"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>修改处理</title>
</head>
<body>
<jsp:useBean id="stuSer" class="service.Kcservice"></jsp:useBean>
<%
int id=Integer.parseInt(request.getParameter("id"));
Kc stu=stuSer.queryStuByID(id);
%>
<form action="xg_0.jsp" method="post">
<table>
<tr><td colspan="2">修改学生信息</td></tr>
<tr>    
      <td><input type="hidden" name="id" value="<%=stu.getId()%>"/></td>
</tr>
<tr>
      <td>课程名称</td>
      <td><input type="text" name="classname" value="<%=stu.getClassname()%>"/></td>
</tr>
<tr>
     <td>教师姓名</td>
     <td><input type="text" name="teachername" value="<%=stu.getTeachername()%>"/></td>
</tr>
<tr>
      <td>上课地点</td>
     <td><input type="text" name="place" value="<%=stu.getPlace()%>"/></td>
</tr>
<tr>
<td align="center" colspan="2">
<input type="submit" value="提交">
<input type="reset" value="重置">

</tr>
</table>
</form>
</body>
</html>

修改结果：xg_0.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<% request.setCharacterEncoding("utf-8"); %>
<jsp:useBean id="kc" class="kecheng.Kc" ></jsp:useBean>
<jsp:useBean id="kcservice" class="service.Kcservice"></jsp:useBean>
<jsp:setProperty property="*" name="kc"/>
<%
if(kcservice.updateStu(kc))
    out.print("success");
else
    out.print("error");
%>
</body>
</html>

查询：chaxun.jsp

<%@page import="kecheng.Kc"%>
<%@page import="java.util.Iterator"%>
<%@page import="java.util.List"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>查询</title>
</head>
<body>
<jsp:useBean id="stuSer" class="service.Kcservice"></jsp:useBean>
<%
List stus=stuSer.queryAllStu();
//out.print(stus.size());
Iterator iter=stus.iterator();
%>
<table>
<tr> <td>ID  </td> <td>课程姓名    </td> <td>教师姓名</td><td>上课地点</td>  </tr>

<%
int i=0;
while(iter.hasNext())
{
    Kc kc=(Kc)iter.next();
    %>
    <tr <%if(i%2==0){ %>bgcolor="#F0F8FF"<%} %>>
    <td> <%=kc.getId() %></td>
    <td> <%=kc.getClassname() %></td>
    <td> <%=kc.getTeachername()%></td>
    <td> <%=kc.getPlace()%></td>
    </tr>
    <%
    i++;
}
%>
</table>
</body>
</html>

数据库的表：

运行结果：

程序首界面：

添加：

查看：

修改：

删除：

数据库：