有道笔记地址:http://note.youdao.com/share/?id=888bd1117e3c127d9acd04ad81f26f57&type=note
throws ServletException,IOException{
String sql = "select * from admin";
Collection retValue = new ArrayList();
SqlBean app = new SqlBean();
try{
ResultSet rs = app.executeQuery(sql);
while(rs.next())
{
//user bean of teacher
TeacherBean tb = new TeacherBean();
tb.setName(rs.getString("userName"));
tb.setSex(rs.getString("userPwd"));
retValue.add(tb);
}
rs.close();
app.dbClose();
}
catch(SQLException e){}
request.setAttribute("teacher",retValue);
String toPath = "/SLT/teacher.jsp";
RequestDispatcher rd = request.getRequestDispatcher(toPath);
rd.forward(request,response);
}
-----
在jsp页面接受
ArrayList al = (ArrayList)request.getAttribute("teacher") ;
for(int i = 0 ; i < al.size() ; i ++)
{
mb = (mvc.TeacherBean)al.get(i);
out.println(mb.getName());
out.println("<br>");
}
%>
JAVA格式化时间日期
import java.util.Date;
import java.text.DateFormat;
/**
* 格式化时间类
* DateFormat.FULL = 0
* DateFormat.DEFAULT = 2
* DateFormat.LONG = 1
* DateFormat.MEDIUM = 2
* DateFormat.SHORT = 3
* @author Michael
* @version 1.0, 2007/03/09
*/
public class Test{
public static void main(String []args){
Date d = new Date();
String s;
/** Date类的格式: Sat Apr 16 13:17:29 CST 2006 */
System.out.println(d);
System.out.println("******************************************");
/** getDateInstance() */
/** 输出格式: 2006-4-16 */
s = DateFormat.getDateInstance().format(d);
System.out.println(s);
/** 输出格式: 2006-4-16 */
s = DateFormat.getDateInstance(DateFormat.DEFAULT).format(d);
System.out.println(s);
/** 输出格式: 2006年4月16日 星期六 */
s = DateFormat.getDateInstance(DateFormat.FULL).format(d);
System.out.println(s);
/** 输出格式: 2006-4-16 */
s = DateFormat.getDateInstance(DateFormat.MEDIUM).format(d);
System.out.println(s);
/** 输出格式: 06-4-16 */
s = DateFormat.getDateInstance(DateFormat.SHORT).format(d);
System.out.println(s);
/** 输出格式: 2006-01-01 00:00:00 */
java.text.DateFormat format1 = new java.text.SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
s = format1.format(new Date());
System.out.println(s);
/** 输出格式: 2006-01-01 00:00:00 */
System.out.println((new java.text.SimpleDateFormat("yyyy-MM-dd hh:mm:ss")).format(new Date()));
/** 输出格式: 20060101000000***/
java.text.DateFormat format2 = new java.text.SimpleDateFormat("yyyyMMddhhmmss");
s = format2.format(new Date());
System.out.println(s);
}
}