基于idea-SSM的驾校在线学习网站系统驾较在线模拟网站考试系统(javaweb-php-asp.netC#-j2ee-springboot)

1 概述

2 数据库表

表4.3 t_gonggao 学习内容表

3 关键代码

package com.action;import java.io.IOException;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;import com.dao.DB;
import com.orm.TAdmin;
import com.orm.Tkecheng;public class kecheng_servlet extends HttpServlet
{public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException {String type=req.getParameter("type");if(type.endsWith("kechengMana")){kechengMana(req, res);}if(type.endsWith("kechengAdd")){kechengAdd(req, res);}if(type.endsWith("kechengDel")){kechengDel(req, res);}}public void kechengAdd(HttpServletRequest req,HttpServletResponse res){String name=req.getParameter("name");String jieshao=req.getParameter("jieshao");String del="no";String sql="insert into t_kecheng values(?,?,?,?)";Object[] params={null,name,jieshao,del};DB mydb=new DB();mydb.doPstm(sql, params);mydb.closed();req.setAttribute("message", "操作成功");req.setAttribute("path", "kecheng?type=kechengMana");String targetURL = "/common/success.jsp";dispatch(targetURL, req, res);}public void kechengDel(HttpServletRequest req,HttpServletResponse res){String sql="update t_kecheng set del='yes' where id="+Integer.parseInt(req.getParameter("id"));Object[] params={};DB mydb=new DB();mydb.doPstm(sql, params);mydb.closed();req.setAttribute("message", "操作成功");req.setAttribute("path", "kecheng?type=kechengMana");String targetURL = "/common/success.jsp";dispatch(targetURL, req, res);}public void kechengMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException{List kechengList=new ArrayList();String sql="select * from t_kecheng where del='no'";Object[] params={};DB mydb=new DB();try{mydb.doPstm(sql, params);ResultSet rs=mydb.getRs();while(rs.next()){Tkecheng kecheng=new Tkecheng();kecheng.setId(rs.getInt("id"));kecheng.setName(rs.getString("name"));kecheng.setJieshao(rs.getString("jieshao"));kechengList.add(kecheng);}rs.close();}catch(Exception e){e.printStackTrace();}mydb.closed();req.setAttribute("kechengList", kechengList);req.getRequestDispatcher("admin/kecheng/kechengMana.jsp").forward(req, res);}public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response) {RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);try {dispatch.forward(request, response);return;} catch (ServletException e) {e.printStackTrace();} catch (IOException e) {e.printStackTrace();}}public void init(ServletConfig config) throws ServletException {super.init(config);}public void destroy() {}
}

4 效果演示

idea或eclipse开发,mysql数据库