sqlclass.java

一个关于EJB的练习程序

package emp2;


import java.util.List;
import java.sql.*;
import java.util.ArrayList;

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

    ResultSet rs;
    JdbcClass objjc = new JdbcClass();
    MeBean mb = new MeBean();
    List list = new ArrayList();
    public SqlClass() {
    }

    public List select() {
        String sql = "SELECT dbo.Departments.depid,dbo.Departments.depname,dbo.Employees.username,dbo.Employees.password,dbo.Employees.name,dbo.Employees.roleid,dbo.Employees.phone, dbo.Employees.email, dbo.Employees.depid AS Expr1,dbo.Roles.roleid AS Expr2, dbo.Roles.rolename FROM dbo.Departments INNER JOIN dbo.Employees ON dbo.Departments.depid = dbo.Employees.depid INNER JOIN dbo.Roles ON dbo.Employees.roleid = dbo.Roles.roleid";

        rs = objjc.executeQuery(sql);
        try {
            while (rs.next()) {
                mb.setDepid(rs.getInt(1));
                mb.setDepname(rs.getString(2));
                mb.setUsername(rs.getString(3));
                mb.setPassword(rs.getString(4));
                mb.setName(rs.getString(5));
                mb.setRoleid(rs.getInt(6));
                mb.setPhone(rs.getString(7));
                mb.setEmail(rs.getString(8));

                list.add(mb);

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

    }
}