Çójsp´ÓÊý¾Ý¿âÖвéµÄ´úÂëÏêϸ½âÊÍ¡£¡£¡£Çë¸ßÊÖ¸ø½²½².
ʲôÒâ˼ѽ£¿Ã»Ã÷°×
ÊÇ»ùÓÚjspµÄ²éѯ¹¦ÄÜÂð£¿ÄÇÒ²ÊÇÒ»ÑùµÄÓÃsqlÓï¾äÀ²£¬Ëæ±ãϸöjspϵͳ£¬¶¼»áÓвéѯ¹¦Äܵġ£
²»¾ÍÊÇÊý¾Ý¿âÁ¬½Ó·ûºÍ²éѯÓï¾äÂð£¿
ÍøÉÏÓкܶà ËÑÒ»ËÑ¿´Ò»¿´¾ÍÃ÷°×ÁË
import java.sql.*;
import java.util.*;
public class BoardDaoImpl extends ConnectionManger implements BoardDao{
private Connection conn=null;//ÓÃÓÚ±£´æÊý¾Ý¿âÁ¬½Ó
private PreparedStatement patmt=null;//ÓÃÓÚÖ´ÐÐsqlÓï¾ä
private ResultSet rs=null;//ÓÃÓÚ±£´æ²éѯ½á¹û¼¯
public Map findBoard() {
// TODO Auto-generated method stub
Map map=new HashMap();
String sql="select boardName from BOARD where parentId=?";
try {
conn=this.getConn();//»ñµÃÊý¾Ý¿âÁ¬½Ó
patmt=conn.prepareStatement(sql);
rs=patmt.executeQuery();//Ö´ÐÐsql,µÃµ½½á¹û¼¯
/*½«½á¹û¼¯ÖеÄÐÅϢȡ³ö±£´æµ½MapÖÐ*/
while(rs.next())
{
Board board=new Board();
board.setParentId(rs.getInt("parentId"));
board.setBoardName(rs.getString("boardName"));
map.put(board.setParentId(rs.getInt("parentId")), board.setBoardName(rs.getString("boardName")));
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
ËÑË÷ÁËһϣºhttp://so.csdn.net/bbsSearchResult.aspx?q=jsp+%e4%bc%a0%e9%80%92&p=1£¬Ã»Óз¢ÏÖÄÜÓõġ£ÒòΪÎÒÊdzõѧjsp£¬Òò´ËÓÐЩҲÐíÄÜÓã¬Ö»ÊÇÎÒ¿´²»Ã÷°×£¿
Ò»¡¢ÎÒµÄÇéÐΣº
a.html ͨ¹ý<form action=&q ......
struts2 hibernate spring »¹ÓÐÆäËüµÄÂð£¬ÕâЩ¿ò¼ÜÊDz»ÊǶ¼ÊǹúÍâµÄ¸ßÊÖ ×Ô¼º¿ª·¢³öÀ´µÄÄØ£¿»¹ÊÇjsp ÔÀ´¾ÍÓеģ¿
WebWork,Wicket,JSF,Tapestry,Freemarker,ibatis,Luncene
×î³£ÓõľÍÊÇÕâÈý¸öÀ²
Íâ¹úÈ˵ļ¼Êõ± ......