} } catch (SQLException e) { // TODO 自动生成的 catch 块 e.printStackTrace(); } finally { bs.closeConn(conn, pstmt); } return isflag; } public boolean addStudent(String id,String name,String age,String sex,String grade,String collage)//添加学生信息 { boolean isflag=false; conn=bs.getConnection(); String sql=\ student values(?,?,?,?,?,?) \ try { pstmt=conn.prepareStatement(sql); pstmt.setString(1, id); pstmt.setString(2, name); pstmt.setString(3, age); pstmt.setString(4, sex); pstmt.setString(5, grade); pstmt.setString(6, collage); int num=pstmt.executeUpdate(); if(num>0) { isflag=true; System.out.println(\添加成功！\ System.out.println(\ } } catch (SQLException e) { // TODO 自动生成的 catch 块 e.printStackTrace(); } finally { bs.closeConn(conn, pstmt); }

return isflag; } public boolean updateStudent(String id,String age)//根据学号修改学生年龄 { boolean isflag=false; conn=bs.getConnection(); String sql=\ try { pstmt=conn.prepareStatement(sql); pstmt.setString(2, id); pstmt.setString(1, age); int num=pstmt.executeUpdate(); if(num>0) { isflag=true; System.out.println(\更新成功！\ System.out.println(\ } } catch (SQLException e) { // TODO 自动生成的 catch 块 e.printStackTrace(); } finally { bs.closeConn(conn, pstmt); } return isflag; } }

登录类：

public class UserImpl implements User {

BaseDao bs=new BaseDao(); Connection conn=null;

PreparedStatement pstmt=null;

public int login(String username, String password) {

//管理员登录

conn=bs.getConnection();

ResultSet rs=null; int ifmanager=3;

String sql=\* from manager where username=? and password=?\; try

{

pstmt=conn.prepareStatement(sql); pstmt.setString(1,username); pstmt.setString(2,password); rs=pstmt.executeQuery();

if(rs.next()) { } else

System.out.println(\登录失败，请校对用户名或者密码\); ifmanager=rs.getInt(4);

System.out.println(\登录成功\);

System.out.println(\);

} { }

catch (SQLException e)

e.printStackTrace();

finally {

bs.closeConn(conn, pstmt, rs); }

jsp代码： Ui界面

<%@ page language=\ contentType=\ pageEncoding=\%>

return ifmanager; }

登录成功后判断跳转到老师端还是学生端：

<%@ page language=\ contentType=\ pageEncoding=\%>

<%@page import=\%> <%@page import=\%>

<%@page import=\%> <%@page import=\%> <%@page import=\%>

<%@page import=\%>

登录跳转界面

String username=request.getParameter(\); String password=request.getParameter(\);

int ifmanager=3;

BaseDao bs=new BaseDao(); Connection conn=null;

PreparedStatement pstmt=null;

conn=bs.getConnection();

ResultSet rs=null;

String sql=\* from manager where username=? and password=?\; try

{

pstmt=conn.prepareStatement(sql); pstmt.setString(1,username); pstmt.setString(2,password); rs=pstmt.executeQuery();

if(rs.next()) { } else

out.print(\登录失败，请校对用户名或者密码\); ifmanager=rs.getInt(4); out.println(\登录成功\); if(ifmanager==0)

{

response.sendRedirect(\);//跳转到教师界 } {

response.sendRedirect(\);//跳转到学生界}

面

else

面

}