scoredao.java

css+Ajax技术实现学员分数查看的功能

package com.accp.teem.server.dao ;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: 北大青鸟ACCP软件制作</p>
 *
 * @author 廖启全
 * @version 1.0
 */

import com.accp.teem.server.entity.Score;
import java.sql.*;
import java.util.*;

public class ScoreDAO
{
    /**
     * 根据姓名查询成绩
     * @param score Score
     * @return Score
     * @throws Exception
     */
    public Score selectByName(Score score) throws Exception
    {
      Connection conn = null ;
      Statement stmt = null ;
      ResultSet rs = null ;
      String sqlMsg = "select name,java,net,js from [score] where name='" + score.getName() + "'" ;

      try
      {
        conn = ConnectionManager.getConnection() ;
        stmt = conn.createStatement() ;
        rs = stmt.executeQuery(sqlMsg) ;
        if(rs.next())
        {
          score.setName(rs.getString("name")) ;
          score.setJava(rs.getFloat("java")) ;
          score.setNet(rs.getFloat("net")) ;
          score.setJs(rs.getFloat("js")) ;
        }
        else
        {
          score = null ;
        }
      }
      catch(Exception ex)
      {
        throw ex ;
      }
      finally
      {
        ConnectionManager.Close(conn, stmt, rs) ;
      }
      return score ;
   }

  /**
   * 查询所有学生姓名
   * @return List
   * @throws Exception
   */
  public List seletAllStudent()throws Exception
  {
    List stuList = new ArrayList();

    Connection conn = null;
    Statement stmt = null;
    ResultSet rs = null;
    String sqlMsg = "select name from [score]";

    try
    {
      conn = ConnectionManager.getConnection();
      stmt = conn.createStatement();
      rs = stmt.executeQuery(sqlMsg);
      while(rs.next())
      {
        Score score = new Score();
        score.setName(rs.getString("name"));
        stuList.add(score);
      }
    }
    catch(Exception ex)
    {
      throw ex;
    }
    finally
    {
      ConnectionManager.Close(conn,stmt,rs);
    }
    return stuList;
  }
}