基于jsp的学生成绩管理系统 - 图文

图4.2 添加学生信息页面

publicvoid InsertStudent(String sid,String sname,String smajor,String sclass,String scode) throws Exception{ ;

}

try{

stmt=dbc.getConnection().createStatement(); stmt.executeUpdate(sql); stmt.close(); Statement stmt=null;

DataBaseConnection dbc=null; dbc=new DataBaseConnection();

String sql=\

VALUES('\+sid+\+sname+\+smajor+\+sclass+\+scode+\

}catch (Exception e){

thrownew Exception(\插入中出现错误！！！\); }finally { }

dbc.close();

2.删除学生信息

图4.3 删除学生信息页面

publicvoid DeletebyID(String sid) throws Exception{

String sql=\+sid+\; Statement stmt=null;

DataBaseConnection dbc=null; dbc=new DataBaseConnection(); try{

stmt=dbc.getConnection().createStatement(); stmt.executeUpdate(sql); stmt.close();

}catch (Exception e){

thrownew Exception(\删除中出现错误！！！\); }finally { }

}

dbc.close();

3.查询学生信息

图4.4 查询学生信息页面

publicVector Select(String sid,String sclass,String smajor)throws Exception{

Vector all=newVector();

String sql1=\; String sql=null; if(sid!=\) {

sql=sql1+\+sid+\; if(sclass!=\) { }

sql=sql+\+sclass+\;

}

if(smajor!=\) { }

sql=sql+\+smajor+\;

else { }

sql=sql+\; Statement stmt=null;

DataBaseConnection dbc=null; dbc=new DataBaseConnection(); try{

stmt = dbc.getConnection().createStatement(); ResultSet rs = stmt.executeQuery(sql); while(rs.next()) {

Student stu=new Student(); stu.setSid(rs.getString(\)); stu.setSname(rs.getString(\)); stu.setSmajor(rs.getString(\)); stu.setSclass(rs.getString(\)); stu.setTcredit(rs.getDouble(\)); stu.setTcreditjd(rs.getDouble(\)); stu.setOcredit(rs.getDouble(\)); stu.setAcredit(rs.getDouble(\)); if(sclass!=\) { } else { }

if(smajor!=\) { } else { }

sql=\;

sql=sql1+\+smajor+\; sql=sql1+\+sclass+\; if(smajor!=\) { }

sql=sql+\+smajor+\;

stu.setEgrade(rs.getDouble(\)); stu.setMajorpm(rs.getInt(\)); stu.setClasspm(rs.getInt(\)); stu.setScode(rs.getString(\)); all.addElement(stu);

}

rs.close();

stmt.close();

} catch (Exception e) {

thrownew Exception(\查询中出现错误！！！\); } finally { dbc.close();

}

return all;

}

public String SelectBySid(String sid) throws Exception{ String sname=null;

String sql=\+sid+ \; Statement stmt=null;

DataBaseConnection dbc=null; dbc=new DataBaseConnection(); try { stmt=dbc.getConnection().createStatement(); ResultSet rs=stmt.executeQuery(sql); while(rs.next()){

sname=rs.getString(\);

}

rs.close(); stmt.close();

} catch (Exception e) {

// TODO: handle exception

thrownew Exception(\查询中出错！！！\); }finally{ dbc.close();

}

return sname;

4.修改学生信息

}

图4.5 修改学生信息页面

publicvoid UpdatebyID(String sid,String sname,String smajor,String sclass,String scode) throws Exception{

String sql=\

sname='\+sname+\+smajor+\+sclass+\+scode+\+sid+\;

Statement stmt=null;

DataBaseConnection dbc=null; dbc=new DataBaseConnection(); try{

stmt=dbc.getConnection().createStatement(); stmt.executeUpdate(sql); stmt.close();

}catch (Exception e){

thrownew Exception(\修改中出现错误！！！\); }finally { }

}

dbc.close();

5.查看留言