src/com/tjzhic/dao/impl/GradeDaoImpl.java

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

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

package com.tjzhic.dao.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import com.tjzhic.dao.GradeDao;
import com.tjzhic.db.ConnectionFactory;
import com.tjzhic.entity.SupGrade;

public class GradeDaoImpl implements GradeDao {

	@Override
	public int gradeAdd(SupGrade supgrade) {
		// TODO Auto-generated method stub
		CourseDaoImpl courseImpl = new CourseDaoImpl();
		String ccode = courseImpl.findCcode(supgrade.getCname());
		supgrade.setCcode(ccode);
		 int rows = 0;
		    Connection con = ConnectionFactory.getConnection();
		    PreparedStatement pre = null;
		    try {
		        String sql = "insert into grade(testcardnum,ccode,score,note) values(?,?,?,?)";
		        pre = con.prepareStatement(sql);
		        pre.setString(1, supgrade.getTestcardnum());
		        pre.setString(2, supgrade.getCcode());
		        pre.setInt(3, supgrade.getScore());
		        pre.setString(4, supgrade.getNote());
		        
		        rows = pre.executeUpdate();
		    } catch (SQLException e) {
		        e.printStackTrace();
		    } finally {
		        try{
		            if (pre!=null)
		                pre.close();
		            if (con != null)
		                con.close();
		        }catch (SQLException e) {
		            e.printStackTrace();
		        }
		    }
		    return rows;

	}

	@Override
	public ArrayList<SupGrade> findByCardnum(String testcardnum) {
		// TODO Auto-generated method stub
		ArrayList<SupGrade> supgrades = new ArrayList<SupGrade>();
		  Connection con = ConnectionFactory.getConnection();
		    PreparedStatement pre = null;
		    try {
		        String sql = "select ccode,score,note from grade where testcardnum=?";
		        pre = con.prepareStatement(sql);
		        pre.setString(1, testcardnum);
			    ResultSet rs = pre.executeQuery();
			    while(rs.next()){