学生信息管理系统,WEB(jsp)-MySQL

package com.vanceinfo.dao; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import com.vanceinfo.datainfo.GroupInfo; import com.vanceinfo.datainfo.Groupsforstu; import com.vanceinfo.datainfo.ProjectInfo; import com.vanceinfo.datainfo.ScoreInfo; import com.vanceinfo.datainfo.StudentInfo; import com.vanceinfo.datainfo.UserInfo; import com.vanceinfo.jdbcutil.Jdbcutil; public class StuDaoImpl implements StuDao{ Statement stmt=null; ResultSet rs=null; public List<GroupInfo> queryAllUserInfos(Connection conn) { List<GroupInfo> groupinfos=new ArrayList<GroupInfo>(); String sql_query="select * from groupinfo"; try { stmt=conn.createStatement(); rs=stmt.executeQuery(sql_query); while(rs.next()){ GroupInfo groupinfo=new GroupInfo(); groupinfo.setGroupid(rs.getString("groupid")); groupinfo.setGrouopname(rs.getString("groupname")); groupinfo.setGroupdescribe(rs.getString("groupdescribe")); groupinfos.add(groupinfo); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return groupinfos; } public List<GroupInfo> querySpecialGroupInfo(String groupid, Connection conn) { String sql_query="select * from groupinfo where groupid='"+groupid+"'"; List<GroupInfo> groupinfo=new ArrayList<GroupInfo>(); try { stmt=conn.createStatement(); rs=stmt.executeQuery(sql_query); while(rs.next()){ GroupInfo groupinfos=new GroupInfo(); groupinfos.setGroupid(rs.getString("groupid")); groupinfos.setGrouopname(rs.getString("groupname")); groupinfos.setGroupdescribe(rs.getString("groupdescribe")); groupinfo.add(groupinfos); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return groupinfo; } public boolean saveGroupinfo(GroupInfo groupinfo, Connection conn) { boolean flag=false; String sql_insert="insert into groupinfo values('"+groupinfo.getGroupid()+"','"+groupinfo.getGroupname()+"','"+groupinfo.getGroupdescribe()+"')"; try { stmt=conn.createStatement(); int count=stmt.executeUpdate(sql_insert); if(count!=0){ flag=true; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return flag; } public boolean updateGroupinfo(GroupInfo groupchange, Connection conn) { boolean flag=false; try{ String update_str="UPDATE groupinfo SET groupname='"+groupchange.getGroupname()+"',groupdescribe='"+groupchange.getGroupdescribe()+"' WHERE groupid='"+groupchange.getGroupid()+"';"; stmt=conn.createStatement(); int return_count=stmt.executeUpdate(update_str); if(return_count==1){ flag=true; } } catch(Exception e){ e.printStackTrace(); } return flag; } public boolean deleteGroupinfo(String groupid,Connection conn) { boolean flag=false; String sql_delete="delete from groupinfo where groupid='"+groupid+"'"; try { stmt=conn.createStatement(); int value=stmt.executeUpdate(sql_delete); if(value>0){ flag=true; } } catch (SQLException e) { e.printStackTrace(); } return flag; } public List<StudentInfo> queryAllStuInfos(Connection conn) { // TODO Auto-generated method stub List<StudentInfo> stuinfos=new ArrayList<StudentInfo>(); String queryallstu="select * from studentinfo"; try{ stmt=conn.createStatement(); rs=stmt.executeQuery(queryallstu); while(rs.next()){ StudentInfo stuinfo=new StudentInfo(); stuinfo.setStudentid(rs.getString("studentid")); stuinfo.setStudentname(rs.getString("studentname")); stuinfo.setStudentage(rs.getString("studentage")); stuinfo.setStudenttel(rs.getString("studenttel")); stuinfo.setStutogroupid(rs.getString("stutogroupid")); if(rs.getString("stuleader").equals("leader")){ stuinfo.setStuleader("组长"); }else{stuinfo.setStuleader("组员");} stuinfos.add(stuinfo); } }catch(SQLException e){ e.printStackTrace(); } return stuinfos; } public List<StudentInfo> querySpecialStuInfo(String studentid, Connection conn) { // TODO Auto-generated method stub List<StudentInfo> stuinfo=new ArrayList<StudentInfo>(); String queryspecialstuid="select * from studentinfo where studentid='"+studentid+"' or studentname='"+studentid+"'"; try{ stmt=conn.createStatement(); rs=stmt.executeQuery(queryspecialstuid); while(rs.next()){ StudentInfo stuinfospecial=new StudentInfo(); stuinfospecial.setStudentid(rs.getString("studentid")); stuinfospecial.setStudentname(rs.getString("studentname")); stuinfospecial.setStudentage(rs.getString("studentage")); stuinfospecial.setStudenttel(rs.getString("studenttel")); stuinfospecial.setStutogroupid(rs.getString("stutogroupid")); if(rs.getString("stuleader").equals("leader")){ stuinfospecial.setStuleader("组长"); }else{stuinfospecial.setStuleader("组员");} stuinfo.add(stuinfospecial); } }catch(SQLException e){ e.printStackTrace(); } return stuinfo; } public boolean addStuinfo(StudentInfo stuinfo, Connection conn) { // TODO Auto-generated method stub boolean flag=false; String sqladd="insert into studentinfo values('"+stuinfo.getStudentid()+"','"+stuinfo.getStudentname()+"','"+stuinfo.getStudentage()+"','"+stuinfo.getStudenttel()+"','"+stuinfo.getStutogroupid()+"','"+stuinfo.getStuleader()+"')"; try{ stmt=conn.createStatement(); int count=stmt.executeUpdate(sqladd); if(count!=0){ flag=true; } }catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return flag; } public boolean updateStuinfo(StudentInfo stuinfo, Connection conn) { // TODO Auto-generated method stub boolean flag=false; try{ String upstu="update studentinfo set studentname='"+stuinfo.getStudentname()+"',studentage='"+stuinfo.getStudentage()+"',studenttel='"+stuinfo.getStudenttel()+"',stutogroupid='"+stuinfo.getStutogroupid()+"',stuleader='"+stuinfo.getStuleader()+"' where studentid='"+stuinfo.getStudentid()+"';"; stmt=conn.createStatement(); int count=stmt.executeUpdate(upstu); if(count==1){ flag=true; } }catch(Exception e){ e.printStackTrace(); } return flag; } public boolean deleteStuinfo(String studentid, Connection conn) { // TODO Auto-generated method stub boolean flag=false; String delstu="delete from studentinfo where studentid='"+studentid+"'"; try{ stmt=conn.createStatement(); int count=stmt.executeUpdate(delstu); if(count>0){ flag=true; } } catch (SQLException e) { e.printStackTrace(); } return flag; } public List<ProjectInfo> queryAllProinfos(Connection conn) { // TODO Auto-generated method stub List<ProjectInfo> proInfos=new ArrayList<ProjectInfo>(); String sql="select * from projectinfo"; try{ stmt=conn.createStatement(); rs=stmt.executeQuery(sql); while(rs.next()){ ProjectInfo proinfo=new ProjectInfo(); proinfo.setProid(rs.getString("projectid")); proinfo.setProname(rs.getString("projectname")); proinfo.setProdes(rs.getString("projectdescribe")); proInfos.add(proinfo); } }catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return proInfos; } public List<ProjectInfo> queryspecialProinfo(String projectid,Connection conn) { // TODO Auto-generated method stub String sql="select * from projectinfo where projectid='"+projectid+"'"; List<ProjectInfo> proinfos=new ArrayList<ProjectInfo>(); try { stmt=conn.createStatement(); rs=stmt.executeQuery(sql); while(rs.next()){ ProjectInfo proinfo=new ProjectInfo(); proinfo.setPro