src/com/ischoolbar/programmer/dao/ScoreDao.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.ischoolbar.programmer.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import com.ischoolbar.programmer.model.Page;
import com.ischoolbar.programmer.model.Score;
import com.ischoolbar.programmer.model.SelectedCourse;

/**
 * 成绩表数据库基础操作
 * 公众号：springmeng
 *
 */
public class ScoreDao extends BaseDao {
	/**
	 * 成绩录入
	 * @param score
	 * @return
	 */
	public boolean addScore(Score score){
		String sql = "insert into s_score values(null,"+score.getStudentId()+","+score.getCourseId()+","+score.getScore()+",'"+score.getRemark()+"')";
		return update(sql);
	}
	
	/**
	 * 修改成绩信息
	 * @param score
	 * @return
	 */
	public boolean editScore(Score score){
		String sql = "update s_score set student_id = " + score.getStudentId();
		sql += ",course_id = " + score.getCourseId();
		sql += ",score = " + score.getScore();
		sql += ",remark = '" + score.getRemark() + "'";
		sql += " where id = " + score.getId();
		return update(sql);
	}
	
	/**
	 * 判断成绩是否录入
	 * @param studentId
	 * @param courseId
	 * @return
	 */
	public boolean isAdd(int studentId,int courseId){
		String sql = "select * from s_score where student_id = " + studentId + " and course_id = " + courseId;
		ResultSet query = query(sql);
		try {
			if(query.next()){
				return true;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}