学生成绩管理系统Java课程设计(8)

┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ 装 ┊ ┊ ┊ ┊ ┊ 订 ┊ ┊ ┊ ┊ ┊ 线 ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊

课程设计纸

try { if(rs.next()){ s.setId(rs.getInt(\ s.setName(rs.getString(\ s.setClasses(rs.getInt(\ s.setSex(rs.getString(\ s.setRace(rs.getString(\ s.setNativeplace(rs.getString(\ s.setDepartment(rs.getString(\ s.setSchoolyear(rs.getString(\ s.setBirth(rs.getString(\ } } catch (SQLException e) { e.printStackTrace(); } conn.queryclose(); return s; } }

/*dao包中的GradeDao 类*/ package dao;

import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import jdbc.DBConnection; import bean.Grade;

public class GradeDao { /*学生成绩查询方法*/ public List queryAll() { DBConnection conn = new DBConnection(); String sql = \ ResultSet rs = conn.doQuery(sql); List list = new ArrayList(); try { while (rs.next()) { Grade grade = new Grade(); //将数据库的信息获取并放到grade中再

将grade依次加入到list中

grade.setId(rs.getInt(\ grade.setName(rs.getString(\ grade.setDepartment(rs.getString(\ grade.setClasses(rs.getInt(\ grade.setEnglish(rs.getFloat(\ grade.setSoft(rs.getFloat(\ grade.setOs(rs.getFloat(\ grade.setJava(rs.getFloat(\ grade.setSum(rs.getFloat(\ grade.setAverage(rs.getFloat(\ grade.setDates(rs.getString(\ list.add(grade);

共 39 页 第 35 页

┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ 装 ┊ ┊ ┊ ┊ ┊ 订 ┊ ┊ ┊ ┊ ┊ 线 ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊

课程设计纸

} } catch (SQLException e) { e.printStackTrace(); } conn.queryclose(); return list; } /*学生成绩添加方法*/ public boolean insertGrade(Grade grade) { DBConnection conn = new DBConnection(); String name = grade.getName(); String department=grade.getDepartment(); int classes =grade.getClasses(); float english=grade.getEnglish(); float soft=grade.getSoft(); float os=grade.getOs(); float java=grade.getJava(); float sum=grade.getSum(); float average=grade.getAverage(); String dates=grade.getDates(); String sql = \

t_grade(name,department,classes,English,soft,os,Java,sum,average,dates) values('\\ int count = conn.Update(sql); if (count > 0) { conn.updateclose(); return true; } else { conn.updateclose(); return false; } } /*按学号查询学生成绩的方法*/ public Grade querybyId(int id){ Grade g =new Grade();

String sql=\ DBConnection conn=new DBConnection(); ResultSet rs=conn.doQuery(sql); try { if(rs.next()){ g.setId(rs.getInt(\ g.setName(rs.getString(\ g.setDepartment(rs.getString(\ g.setClasses(rs.getInt(\ g.setEnglish(rs.getFloat(\ g.setSoft(rs.getFloat(\ g.setOs(rs.getFloat(\ g.setJava(rs.getFloat(\ g.setSum(rs.getFloat(\ g.setAverage(rs.getFloat(\

共 39 页 第 36 页

┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ 装 ┊ ┊ ┊ ┊ ┊ 订 ┊ ┊ ┊ ┊ ┊ 线 ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊

课程设计纸

} } catch (SQLException e) { e.printStackTrace(); } conn.queryclose(); return g; } /*学生成绩修改方法*/ public boolean AlterGrade(Grade g){ float english=g.getEnglish(); float soft=g.getSoft(); float os=g.getOs(); float java=g.getJava(); float sum=english+soft+os+java; float average=sum/4; DBConnection conn=new DBConnection(); String sql=\

English=\average=\ int count=conn.Update(sql); if(count>0){ conn.updateclose(); return true; }else{ conn.updateclose(); return false; } } }

/*dao包中的TongjiDao类*/ package dao;

import java.sql.ResultSet; import java.sql.SQLException;

import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Date; import java.util.Iterator; import java.util.List; import jdbc.DBConnection; import bean.Tongji;

public class TongjiDao { /*班级成绩的查询方法*/ public List queryAll() { DBConnection conn = new DBConnection(); String sql = \ ResultSet rs = conn.doQuery(sql); List list = new ArrayList(); try { while (rs.next()) { Tongji t = new Tongji();

共 39 页 第 37 页

┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ 装 ┊ ┊ ┊ ┊ ┊ 订 ┊ ┊ ┊ ┊ ┊ 线 ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊

课程设计纸

t.setId(rs.getInt(\ t.setClasses(rs.getInt(\ t.setSum(rs.getFloat(\ t.setAverage(rs.getFloat(\ t.setDates(rs.getString(\ list.add(t); } } catch (SQLException e) { e.printStackTrace(); } conn.queryclose(); return list; } /*按班级号查询班级成绩的方法*/ public List selectbyClasses(int classes){ DBConnection conn=new DBConnection(); String sql=\ ResultSet rs=conn. doQuery(sql); List list = new ArrayList(); try { while (rs.next()) { Tongji t = new Tongji(); t.setId(rs.getInt(\ t.setClasses(rs.getInt(\ t.setSum(rs.getFloat(\ t.setAverage(rs.getFloat(\ t.setDates(rs.getString(\ list.add(t); } } catch (SQLException e) { }conn.queryclose(); return list; } /*班级成绩的添加方法*/ public boolean insert(int classes,float sum,String dates){ DBConnection conn=new DBConnection(); Tongji t=new Tongji(); float sum1=sum; float average=sum1/1; List list=list=selectbyClasses(classes); Iterator it = list.iterator(); if(it.hasNext()){ int i=list.size(); t=(Tongji)list.get(i); sum1=t.getSum()+sum; average=sum1/(i+1); }else{ } String sql=\

values(\ int count = conn.Update(sql);

共 39 页 第 38 页

┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ 装 ┊ ┊ ┊ ┊ ┊ 订 ┊ ┊ ┊ ┊ ┊ 线 ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊

课程设计纸

} }

if (count > 0) { conn.updateclose(); return true; } else { conn.updateclose(); return false; }

共 39 页 第 39 页

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库学生成绩管理系统Java课程设计(8)在线全文阅读。