courcedao.java

来自「这是一个员工管理系统」· Java 代码 · 共 75 行

package com.orilore.ssms.dao;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.SQLException;
import com.orilore.ssms.entity.Student;
import java.util.*;
import com.orilore.ssms.entity.Cource;
import com.orilore.ssms.entity.Score;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2009</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class CourceDao {
    public CourceDao() {
    }

    public int findIdByName(String name){
        Connection conn = DbManager.getConn();
        PreparedStatement pst = null;
        int id = 0;
        try {
            pst = conn.prepareStatement("select id from cource where cname=?");
            pst.setString(1,name);
            ResultSet rs = pst.executeQuery();
            if(rs.next()){
                id = rs.getInt("id");
            }
            rs.close();
            pst.close();
            conn.close();

        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return id;

    }

    public List<Cource> findAll(){
        List<Cource> list = new ArrayList<Cource>();
        Connection conn = DbManager.getConn();
        PreparedStatement pst = null;
        try {
            pst = conn.prepareStatement("select * from cource");
            ResultSet rs = pst.executeQuery();
            while(rs.next()){
                Cource c = new Cource();
                c.setId(rs.getInt("id"));
                c.setCname(rs.getString("cname"));
                list.add(c);

            }
            rs.close();
            pst.close();
            conn.close();

        } catch (SQLException ex) {
            ex.printStackTrace();
        }

        return list;
    }
}