scoredao.java~22~

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
{
    /**
     * 根据姓名查询成绩
     */
  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;
  }

  public List seletAllStudent()
  {
    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);
      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 stuList;
  }
}