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+"\n");
         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+"\n");
         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>

数据库的表：

运行结果：

程序首界面：

添加：

查看：

修改：

删除：

数据库：