package bean;
public class Student {
      private String studentName;
      private String sex;
      public String getStudentName() {
            return studentName;
      }
      public void setStudentName(String studentName) {
            this.studentName = studentName;
      }
      public String getSex() {
            return sex;
      }
      public void setSex(String sex) {
            this.sex = sex;
      }
      public Student(String studentName, String sex) {
            super();
            this.studentName = studentName;
            this.sex = sex;
      }
      public Student() {
            super();
      }
}
package dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import db.DBConection;
import bean.Student;
public class StudentDao {
      private Connection conn = null;
      private PreparedStatement ps = null;
      private ResultSet rs = null;
      private Student student = null;
      private ArrayList<Student> studentlist = null;
      public ArrayList<Student> getAll(){
            conn = DBConection.getConnection();
            studentlist = new ArrayList<Student>();
            try {
                  ps = conn.prepareStatement("select * from studentinfo");
                  rs = ps.executeQuery();
                  while(rs.next()){
                        System.out.print("wwwwwwwwwwwwwwwwwwwwwwwwwwwwwww");
                        student = new Student(rs.getString(1),rs.getString(2));
                        studentlist.add(student);
                  }
            } catch (SQLException e) {
                  // TODO Auto-generated catch block
                  e.printStackTrace();
            } finally{
      }
      return studentlist;
}
}
package db;
import java.sql.Connection;
import java.sql.SQLException;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
public class DBConection {
      private static Connection conn;
      /**

 * 获取数据连接

 * @return

 */
      public static Connection getConnection(){
            try {
                  Context ctx = new InitialContext();
                  DataSource ds = (DataSource) ctx.lookup("student");
                  conn = ds.getConnection();
            } catch (NamingException e) {
                  // TODO Auto-generated catch block
                  e.printStackTrace();
            } catch (SQLException e) {
                  // TODO Auto-generated catch block
                  e.printStackTrace();
            }
            return conn;
      }
}

<table border="1">
<tr><td>姓名</td><td>性别</td></tr>
<%
ArrayList<Student> student = new StudentDao().getAll();
System.out.println("姓名\t\t性别");
Iterator it = student.iterator();
while(it.hasNext()){
      Student stu = (Student)it.next();
      System.out.println(stu.getStudentName()+"\t"+stu.getSex());
      out.print("<tr><td>问问"+stu.getStudentName()+"</td><td>"+stu.getSex()+"问问</td></tr>");
}
%>
</table>

C:\oracle\middle\user_projects\domains\base_domain\bin

set CLASSPATH=%PRE_CLASSPATH%;%WEBLOGIC_CLASSPATH%;%POST_CLASSPATH%;%WLP_POST_CLASSPATH%;%WL_HOME%\server\lib\mysql-connector-java-commercial-5.1.17-bin.jar