achievementdao.java

C语言小型分析器实验报告1） 待分析的简化C语言的词法说明； 2） 单词符号的种别编码方案； 3） 所识别的各类单词符号的正规式或状态转换图； 4） 待分析的简化C语言的语法规则说明； 5）

package dao;

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

public class AchievementDao {
	
	private String number;
	private String course;
	private int score;
	private BasicDao dao;
	
	public AchievementDao(){
		dao = new BasicDao();
	}
	
	public AchievementDao(String number){
		this.number = number;
		dao = new BasicDao();
	}
	
	public AchievementDao(String number, String course, String score){
		this.number = number;
		this.course = course;
		this.score = Integer.parseInt(score);
		dao = new BasicDao();
	}
	
	public int insertAchievement(){
		String sql = "insert into achievement(number, course, score)values('" + number + "','" + course + "'," +score + ")";
		int result = 0;
		try {
			result = dao.executeString(sql);
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			dao.closeAll();
		}
		return result;
	}
	
	public ResultSet queryAchievement(){
		ResultSet result = null;		
		String sql = "select number,course,score from achievement where number='" + number + "'";
		try {
			result = dao.queryString(sql);
			System.out.println(result);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return result;
	}
	
	public void closeAll(){
		if(dao!=null)
			dao.closeAll();
	}
}