/**
*
*/
package com.xscj.dao.impl;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BatchPreparedStatementSetter;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowCallbackHandler;
import org.springframework.stereotype.Repository;
import com.xscj.dao.ScoreDao;
import com.xscj.domain.IDNameScore;
import com.xscj.domain.Score;
import com.xscj.domain.ScoreByGCXT;
import com.xscj.domain.ScoreByGidCid;
import com.xscj.domain.ScoreBySXT;
import com.xscj.domain.ScoreCount;
import com.xscj.domain.ScoreGroup;
import com.xscj.domain.ScorePart;
import com.xscj.domain.ScoreXueqi;
import com.xscj.domain.SimpleScore;
import com.xscj.domain.StuScoreCount;
/**
* @author leorain
*@date 2014-3-24 下午8:19:50
*/
@Repository
public class JdbcScoreDaoImpl implements ScoreDao {
@Autowired
private JdbcTemplate jdbcTemplate;
@Override
public void addScoresToDb(final List<Score> scores) {
String sqlString = "INSERT INTO sp_score_record(sr_gradeid,sr_stuid, sr_courseid, sr_examtime" +
", sr_examtype, sr_xueqi, sr_score) VALUES(?,?,?,?,?,?,?);";
jdbcTemplate.batchUpdate(sqlString, new BatchPreparedStatementSetter() {
@Override
public void setValues(PreparedStatement ps, int index) throws SQLException {
Score score = scores.get(index);
ps.setString(1, score.getGradeID());
ps.setInt(2, score.getStuXueHao());
ps.setString(3, score.getCourseID());
ps.setString(4, score.getExamTime());
ps.setString(5, score.getExamType());
ps.setInt(6, score.getXueqi());
ps.setDouble(7, score.getScore());
}
@Override
public int getBatchSize() {
return scores.size();
}
});
}
@Override
public List<SimpleScore> getSimpleScores(String gradeID, String courseID,
String examType, String examTime, int xueqi) {
String sqlString = "SELECT sr_stuid, sr_score FROM sp_score_record WHERE sr_gradeid=? AND sr_courseid=? AND sr_examtime=? AND sr_examtype=? AND sr_xueqi=?;";
Object[] argsObjects = {gradeID, courseID, examTime, examType, xueqi};
final List<SimpleScore> simpleScores = new ArrayList<SimpleScore>();
jdbcTemplate.query(sqlString, argsObjects, new RowCallbackHandler() {
@Override
public void processRow(ResultSet rs) throws SQLException {
SimpleScore simpleScore = new SimpleScore();
simpleScore.setXuehao(rs.getInt("sr_stuid"));
simpleScore.setScore(rs.getDouble("sr_score"));
simpleScores.add(simpleScore);
}
});
return simpleScores;
}
@Override
public List<ScorePart> getScoreParts(String gradeID, int xueqi,
int stuXueHao) {
String sqlString = "SELECT sr_courseid, c_name, sr_examtime, sr_examtype, sr_score FROM sp_score_record, sp_course WHERE sr_gradeid= ? AND sr_xueqi = ? AND sr_stuid = ? AND sp_course.c_id = sp_score_record.sr_courseid;";
Object[] argsObjects = {gradeID, xueqi, stuXueHao};
final List<ScorePart> scoreParts = new ArrayList<ScorePart>();
jdbcTemplate.query(sqlString, argsObjects, new RowCallbackHandler() {
@Override
public void processRow(ResultSet rs) throws SQLException {
ScorePart scorePart = new ScorePart();
scorePart.setCourseID(rs.getString("sr_courseid"));
scorePart.setCourseName(rs.getString("c_name"));
scorePart.setExamTime(rs.getString("sr_examtime"));
scorePart.setExamType(rs.getString("sr_examtype"));
scorePart.setScore(rs.getDouble("sr_score"));
scoreParts.add(scorePart);
}
});
return scoreParts;
}
@Override
public List<ScorePart> getScorePartsByXueHao(int stuXueHao) {
String sqlString = "SELECT sr_courseid, c_name, sr_examtime, sr_examType, sr_score FROM sp_score_record, sp_course WHERE sr_stuid = ? AND sp_course.c_id = sp_score_record.sr_courseid;";
Object[] args = {stuXueHao};
final List<ScorePart> scoreParts = new ArrayList<ScorePart>();
jdbcTemplate.query(sqlString, args, new RowCallbackHandler() {
@Override
public void processRow(ResultSet rs) throws SQLException {
ScorePart scorePart = new ScorePart();
scorePart.setCourseID(rs.getString("sr_courseid"));
scorePart.setCourseName(rs.getString("c_name"));
scorePart.setExamTime(rs.getString("sr_examtime"));
scorePart.setExamType(rs.getString("sr_examtype"));
scorePart.setScore(rs.getDouble("sr_score"));
scoreParts.add(scorePart);
}
});
return scoreParts;
}
@Override
public List<ScoreXueqi> getScoreXueqis(int stuXueHao, String courseID) {
String sqlString = "SELECT sr_xueqi, sr_examtime, sr_examtype, sr_score FROM sp_score_record WHERE sr_stuid = ? AND sr_courseid = ?;";
Object[] argsObjects = {stuXueHao, courseID};
final List<ScoreXueqi> scoreXueqis = new ArrayList<ScoreXueqi>();
jdbcTemplate.query(sqlString, argsObjects, new RowCallbackHandler() {
@Override
public void processRow(ResultSet rs) throws SQLException {
ScoreXueqi scoreXueqi = new ScoreXueqi();
scoreXueqi.setXueqi(rs.getInt("sr_xueqi"));
scoreXueqi.setExamTime(rs.getString("sr_examtime"));
scoreXueqi.setExamType(rs.getString("sr_examtype"));
scoreXueqi.setScore(rs.getDouble("sr_score"));
scoreXueqis.add(scoreXueqi);
}
});
return scoreXueqis;
}
@Override
public List<ScoreByGidCid> getScoreByGidCids(String gradeID, String courseID) {
String sqlString = "SELECT sr_stuid, s_name, sr_examtime, sr_examtype, sr_xueqi, sr_score FROM sp_score_record, sp_student WHERE sr_gradeid = ? AND sr_courseid = ? AND sp_student.s_id = sp_score_record.sr_stuid;";
Object[] argsObjects={gradeID, courseID};
final List<ScoreByGidCid> scoreByGidCids = new ArrayList<ScoreByGidCid>();
jdbcTemplate.query(sqlString, argsObjects, new RowCallbackHandler() {
@Override
public void processRow(ResultSet rs) throws SQLException {
ScoreByGidCid scoreByGidCid = new ScoreByGidCid();
scoreByGidCid.setStuXueHao(rs.getInt("sr_stuid"));
scoreByGidCid.setStuName(rs.getString("s_name"));
scoreByGidCid.setExamTime(rs.getString("sr_examtime"));
scoreByGidCid.setExamType(rs.getString("sr_examtype"));
scoreByGidCid.setXueqi(rs.getInt("sr_xueqi"));
scoreByGidCid.setScore(rs.getDouble("sr_score"));
scoreByGidCids.add(scoreByGidCid);
}
});
return scoreByGidCids;
}
@Override
public List<ScoreBySXT> getScoreBySXTs(int stuXueHao, int xueqi,
String examType) {
String sqlString = "SELECT sr_courseid, c_name, sr_examtime, sr_score FROM sp_score_record, sp_course WHERE sr_stuid = ? AND sr_xueqi = ? AND sr_examtype = ? AND sp_score_record.sr_courseid=sp_course.c_id";
Object[] argsObjects = {stuXueHao, xueqi, examType};
final List<ScoreBySXT> scoreBySXTs = new ArrayList<ScoreBySXT>();
jdbcTemplate.query(sqlString, argsObjects, new RowCallbackHandler() {
@Override
public void processRow(ResultSet rs) throws SQLException {
ScoreBySXT scoreBySXT = new ScoreBySXT();
scoreBySXT.setCourseID(rs.getString("sr_courseid"));
scoreBySXT.setCourseName(rs.getString("c_name"));
scoreBySXT.setExamTime(rs.getString("sr_examtime"));
scoreBySXT.setScore(rs.getDouble("sr_score"));
scoreBySXTs.add(scoreBySXT);
}
});
return scoreBySXTs;
}
@Override
public List<ScoreByGCXT> getscByGCXTs(String gradeID, String courseID,
int xueqi, String examType) {
String sqlsString = "SELECT sr_stuid, s_name, sr_examtime, sr_score FROM sp_score_record, sp_student WHERE sr_gradeid = ? AND sr_courseid = ? AND sr_xueqi = ? AND sr_examtype = ? AND sp_score_record.sr_stuid = sp_student.s_id;";
Object[] argObjects = {gradeID,courseID,xueqi,examType};
final List<ScoreByGCXT> scoreByGCXTs = new ArrayList<ScoreByGCXT>();
jdbcTemplate.query(sqlsString, argObjects, new RowCallbackHandler() {
@Override
public void processRow(ResultSet rs) throws SQLException {
ScoreByGCXT scoreByGCXT
基于Java MySQL实现学生管理系统【优质毕业设计、课程设计项目】.zip （617个子文件） 
JdbcScoreDaoImpl.class 15KB ScorePrinterGradeSucAction.class 9KB JdbcTeachingArrangeDaoImpl.class 8KB JdbcStuDaoImpl.class 8KB ScorePrinterSucAction.class 8KB JdbcGradeDaoImpl.class 8KB TeacherScoreAddSucAction.class 8KB ScoreRecordFinishAction.class 7KB ScoreVariationLineAction.class 7KB ScoreAnalyzeThirdAction.class 7KB ScoreServiceImpl.class 7KB ScoreAnalyzeFiveAction.class 7KB JdbcTeacherDaoImpl.class 7KB ScoreCountAnalyzeAction.class 6KB ScoreAnalyzeAction.class 6KB TeachingArrangeFormAction.class 5KB ScoreAnalyzeSecondAction.class 5KB JdbcCourseDao.class 5KB TeacherScoreAddAction.class 5KB ScoreEnterSimpleStuSucAction.class 5KB ScoreRankPieAction.class 5KB TeacherScoreSeeingAction.class 5KB TeacherScoreModifyAction.class 5KB TeacherScoreDelAction.class 5KB ScoreEnterTestAction.class 4KB ScoreCountSucAction.class 4KB TeacherScoreDelSucAction.class 4KB ScoreEnterFormAction.class 4KB ScoreDeleteResultGradeSucAction.class 4KB StuScoreSearchAction.class 4KB TeacherScoreModifySucAction.class 4KB ScoreQueryResultAction.class 4KB ScoreModifyResultGradeSucAction.class 4KB TeacherTeachingAction.class 4KB LoginJudgeAction.class 4KB ScoreRankBar3DAction.class 4KB ScoreDeleteResultSucAction.class 4KB ScoreDeleteResultAction.class 4KB ScoreModifyResultAction.class 4KB TeachingArrangeImpl.class 4KB ScoreEnterSimpleStuAction.class 4KB ScoreQueryResultFourAction.class 4KB ScoreModifyResultSucAction.class 4KB ScoreCountTestAction.class 4KB TeachingArrangeFormRegisterAction.class 3KB ScoreCountNianJiAction.class 3KB ScoreRecordAction.class 3KB ScoreQueryResultSecondAction.class 3KB StuServiceImpl.class 3KB ScoreQueryResultFiveAction.class 3KB ScoreDeleteResultGradeAction.class 3KB ScoreModifyResultGradeAction.class 3KB TeachingArrangeModifyAction.class 3KB TeachingArrangeSeeAction.class 3KB ScoreService.class 3KB ScoreDao.class 3KB GradeSetUpImpl.class 3KB Teacher.class 3KB ScoreEnterStuTestAction.class 3KB GradeSetUpAction.class 3KB ScoreModifyStuTestAction.class 3KB TeacherSeeingAction.class 3KB AdminPassModifyAction.class 3KB TeacherManagerImpl.class 3KB TeacherPassModifyAction.class 3KB PassModifyAction.class 3KB StuModifyAction.class 3KB ScoreQueryStuTypeXqTestAction.class 3KB SimpleStudent.class 3KB ScoreQueryLastTestAction.class 3KB MakeCertPic.class 3KB ScoreQueryStuCidTestAction.class 3KB Student.class 2KB StuMainAction.class 2KB JdbcScoreDaoImpl$15.class 2KB ScoreExisitsTestAction.class 2KB TeacherMainAction.class 2KB StuSearchSucByGradeAction.class 2KB StuFormRegisterAction.class 2KB ScoreQueryStuTestAction.class 2KB TeacherFormRegisterAction.class 2KB StuSearchTestAction.class 2KB ScoreQueryGradeCidTestAction.class 2KB TeacherModifyAction.class 2KB StuSeeingAction.class 2KB TeachingArrangeModifySucAction.class 2KB TeacherSearchTestAction.class 2KB CoursePlanImpl.class 2KB JdbcStuDaoImpl$7.class 2KB ScoreEnterChoseAction.class 2KB JdbcStuDaoImpl$1.class 2KB JdbcStuDaoImpl$6.class 2KB ShowAllTeacherAction.class 2KB ShowAllStuAction.class 2KB StuSearchGradeTestAction.class 2KB TeacherDeleteAction.class 2KB TeachingTable.class 2KB ScoreGroup.class 2KB StuModifySucAction.class 2KB ScoreModifyAction.class 2KB共 617 条
- 1
- 2
- 3
- 4
- 5
- 6
- 7
资源评论
