数据库课程设计报告 - 考试监考管理系统 - 图文(6)

攀枝花学院本科课程设计（论文） 5 系统实现

String area=request.getParameter(\); String time=request.getParameter(\); String didian=request.getParameter(\); Arrange_update a_u=new Arrange_update(); try { }

out.println(\修改完成\); out.write(\); out.write(\

a_u.update(aid, cname, teachername, area, time,didian);

e.printStackTrace();

} catch (Exception e) {

href='http://localhost:8080/DB_Design/adminlogin.jsp'>返回\); } ImageServlet.java

public class ImageServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse

throws ServletException, IOException {

response)

response.setHeader(\, \);

response.setHeader(\, \); response.setDateHeader(\, 0); int width = 60, height = 20;

BufferedImage image = new BufferedImage(width, height,

BufferedImage.TYPE_INT_RGB);

Graphics g = image.getGraphics(); Random random = new Random();

g.setColor(new Color(255,255, 255)); g.fillRect(0, 0, width, height);

g.setFont(new Font(\, Font.PLAIN, 18)); g.setColor(Color.red);

for (int i = 0; i < 20; i++) { }

String sRand = \;

for (int i = 0; i < 4; i++) {

String rand = String.valueOf(random.nextInt(10)); sRand += rand;

g.setColor(new Color(30 + random.nextInt(160), 40 + random

.nextInt(170), 40 + random.nextInt(180)));

int x = random.nextInt(width); int y = random.nextInt(height); int xl = random.nextInt(12); int yl = random.nextInt(12); g.drawLine(x, y, x + xl, y + yl);

21

攀枝花学院本科课程设计（论文） 5 系统实现

}

}

g.drawString(rand, 13 * i + 6, 16);

request.getSession().setAttribute(\, sRand); g.dispose();

ImageIO.write(image, \, response.getOutputStream());

loginServlet.java

public class loginServlet extends HttpServlet{

protected void doPost(HttpServletRequest request, }

protected void doGet(HttpServletRequest request, HttpServletResponse

throws ServletException, IOException { response.setContentType(\); request.setCharacterEncoding(\); response.setCharacterEncoding(\); PrintWriter out=response.getWriter();

String position=request.getParameter(\); String uyzm=request.getParameter(\); String username=request.getParameter(\); String pwd=request.getParameter(\); String

if(!uyzm.equals(yzm)){

response.sendRedirect(\验证码错误\); }

login l=new login();

Teacherlogin t= new Teacherlogin(); try {

if(position.equals(\)){

if(t.login_yz(username, pwd)){

response.sendRedirect(\);} else{

out.println(\密码错误或用户不存在\); out.write(\); out.write(\

throws ServletException, IOException {

HttpServletResponse response)

doGet(request, response);

response)

yzm=request.getSession().getAttribute(\).toString();

href='http://localhost:8080/DB_Design/index.jsp'>返回登录页面\); }

}

else if(position.equals(\)){

if(l.login_yz(username,pwd)){

22

攀枝花学院本科课程设计（论文） 5 系统实现

response.sendRedirect(\); } else{

out.println(\密码错误或用户不存在\); out.write(\); out.write(\

href='http://localhost:8080/DB_Design/index.jsp'>返回登录页面\); } }

teacherServlet.java

public class teacherServlet extends HttpServlet{

protected void doGet(HttpServletRequest request, HttpServletResponse

throws ServletException, IOException { response.setContentType(\); request.setCharacterEncoding(\); response.setCharacterEncoding(\); PrintWriter out=response.getWriter();

String teachername=request.getParameter(\); teacher t=new teacher();

out.println(\);

out.println(\安排编号课程名监考老师

response)

}

}

}

e.printStackTrace(); } catch (Exception e) {

监考校区监考时段\); try {

for(int i=0;i

arrange a=(arrange)t.getInfo(teachername).get(i);

out.println(\+a.getId()+\+a.getCname()+\

td>\+a.getTeacherName()+\+a.getArea()+\+a.getTime()+\);

}

out.write(\); out.write(\

}

e.printStackTrace();

} catch (Exception e) {

href='http://localhost:8080/DB_Design/teacherlogin.jsp'>返回\); }

5.4.3 Dao

23

攀枝花学院本科课程设计（论文） 5 系统实现

public class arrange { String id; String cname; String teachername; String area; String time; String didian; public arrange(){}

public arrange(String id,String cname,String teachername,String area,String time,String didian){

this.id=id; this.cname=cname;

this.teachername=teachername; this.area=area; this.time=time; this.didian=didian;

}

public String getId() { return id; }

public void setId(String id) { this.id = id; }

public String getCname() { return cname; }

public void setCname(String cname) { this.cname = cname; }

public String getTeacherName() { return teachername; }

public void setTeacher(String teacher) { this.teachername = teacher; }

public String getArea() { return area;

}

public void setArea(String area) { this.area = area; }

public String getTime() { return time;

}

24

攀枝花学院本科课程设计（论文） 5 系统实现

}

public void setTime(String time) { }

public String getDidian() { }

public void setDidian(String didian) { }

this.didian = didian; return didian; this.time = time;

5.4.4 JavaBean

public class Arrange_add {

Class.forName(\); String

public void arr_add(String cname,String teachername,String area,String time,String didian)throws Exception{

url=\hwind\;

Connection con=DriverManager.getConnection(url); Statement cmd=con.createStatement(); int aid1=0;

String sql2=\; ResultSet rs = cmd.executeQuery(sql2); while(rs.next()){ }

aid1=aid1+1;

String sql=\

int aid2=Integer.parseInt(rs.getString(1)); if(aid1

aid1=aid2;

('\+aid1+\+cname+\+teachername+\+area+\+time+\+didian+\;

cmd.executeQuery(sql); con.close(); }}

public class Arrange_update {

public void update(String a_id,String c_name,String

String cname; String teachername; String area;

t_eachername,String a_rea,String t_ime,String d_idian)throws Exception{

25