SQLÓï¾äÕýÈ·µ«ÊÇRESULTSETÖÐûÓÐÖµ
StringBuffer str = new StringBuffer("select * from menu where parentid=1 and mid <>1 order by parentid");
List list = new ArrayList();
ResultSet rst = null;
DataBaseConnection dbc = null;
PreparedStatement pstm = null;
try {
dbc = new DataBaseConnection();
pstm = dbc.getConnection().prepareStatement(str.toString());
rst = dbc.query(pstm);
while(rst.next()){
System.out.println(rst.getString("name"));
}
RSTÖÐûÓÐÈκÎÖµ
Êý¾Ý¿â ORACLE 10G
²»ÖªµÀÄãµÄÊÇÔõô·â×°µÄ²éѯ£¬ÓÐÎÊÌâÒ»¶¨ÊÇdbc.query(pstm)ûÓеõ½ÕýÈ·µÄ½á¹û¼¯
Ϊʲô²»Ö±½Ó²éÑ¯ÄØ£¿
try {
dbc = new DataBaseConnection();
pstm = dbc.getConnection().prepareStatement(str.toString());
rst = pstm.executeQuery();
while(rst.next()){
System.out.println(rst.getString("name"));
}
public ResultSet query(PreparedStatement pstm) throws SQLException,
Exception {
this.rst = pstm.executeQuery();
return rst;
}
ÕâÊǺǫ́²éѯ
·â×°Õâ¸ö·½·¨ºÃÏñûɶÒâÒå°¡
ÄãµÄsqlÔÚ¹¤¾ßÀïÄܲé³ö¶«Î÷Âð£¿
public ResultSet query(PreparedStatement pstm) throws SQLException,
Exception {
return pstm.executeQuery();
}
PLSQL DEVELOPER Äܲé³öÀ´£¬½á¹ûÕýÈ·
Ö
Ïà¹ØÎÊ´ð£º
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡
Ëæ±ã¸ãÒ»D°æ°É£¬
ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù
http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID
1,Name1....test1,1,99
1,Name1....test1,3,99
1,Name2....test2,1,101
1,Name2....test2,3,101
1,Name3....test3,2,101
1,Name1....test1,4,101
ÏëÒªµÄ½á¹ûÊÇ:
1,Na ......
¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......
Ö´ÐÐÊý¾Ý¿â²Ù×÷ʱ£¬Ö±½ÓÓÃSQL Óï¾äºÃһЩ »¹ÊÇÓô洢¹ý³Ì¸ü¼ÑÄØ£¿
¸÷ÊãÆð¼û
Õâ¸öµÄ¾ßÌåÎÊÌâ¾ßÌå·ÖÎö
¼òµ¥µÄselect ¡¢updateºÍinsertµ±È»sql½â¾öÁË
¸´ÔӵķÅÔÚsql·þÎñ¶ËÓ¦¸ÃºÃµã
Â¥Ö÷Çë²ÎÔÄ
http://msdn.micr ......