Java ÀàÖÐselectÓï¾äÎÊÌâ
ÏÈ¿´Ð¡¶Î´úÂ룺
public class a
{
private int Team_Id;
public int getTeam_Id()
{
return Team_Id;
}
public void setTeam_Id(int team_Id)
{
Team_Id = team_Id;
}
public String execute() throws Exception
{
System.out.println(Team_Id);
String sql="select * from Team where Team_Id='Team_Id'";
ResultSet rs=dao.executeQuery(sql);
}
}
ÀàÖÐTeam_IdÊÇintÐÍ£¬±íTeamÖеÄTeam_IdÒ²ÊÇintÐ͵ġ£
ͨ¹ý´«Öµ¿ÉÒԵõ½Team_Id=9,ºǫ́Êä³öÕý³£¡£µ«ÊÇÔÚÖ´ÐÐÉÏÃæexecute()ÖеIJéѯʱ£¬sqlÓï¾ä¾Í³ö´í¡£ÇëÎÊÓ¦¸ÃÔõôдÄǸöÓï¾ä¡£ÎÒÒѾÊÔ¹ýTeam_Id='Team_Id'¡¢Team_Id='"+Team_Id+"'¡¢Team_Id=Team_Id¡£µ«ÊǶ¼²»ÐС£ÓÐËÖªµÀÂð£¿Ð»Ð»£¡
Í·ÌÛ£¬°ï¶¥
ResultSet rs=dao.executeQuery(sql);
--------------------------------------
daoÊÇʲô£¿
String sql="select * from Team where Team_Id="+Team_Id;
String sql="select * from Team where Team_Id="+Team_Id;
Ö´ÐÐÊǵÄÓï¾äÓ¦¸ÃÊÇÖ÷º¯Êý£º
public static void main(string[]args){}¼ÓÉÏÄãÏëʵÏÖµÄÄÚÈÝÄã¿ÉÒÔÊÔÊÔ£¡
daoÊǸöÀà¶ÔÏó£¬ÉÏÃæÃ»ÓÐд³öÀ´£¬ÊÇÎÒרÃÅдµÄ²Ù×÷Êý¾Ý¿âµÄÀà¡£
String sql="select * from Team where Team_Id="+Team_I
Ïà¹ØÎÊ´ð£º
ÎÒµÄjava applet ǶÈëhtmlºóÎÞ·¨ÏÔʾ£¬¶øÓÃappletviewerÏÔʾÕý³£ÎªÊ²Ã´£¬»¹ÓоÍÊÇÓÃhtml converterת»¯ºó¿ÉÒÔÏÔʾ£¬ÎªÊ²Ã´£¿Çë´óÏÀ´Í½Ì£¡
HTML code:
<HTML>
<HEAD>
<TITLE>TEST.HTML< ......
ÎÒÏëÓÃJavaдһ¸ö³ÌÐò£¬¾ÍÊÇÎÒÏëÔÚÔËÐдúÂëºó£¬ÔÚÖ¸¶¨µÄʱ¼ä´ò¿ªÄ³³ÌÐò£¬ÀýÈçÎÒÔËÐдúÂëºó£¬½²ÔÚ12£º00´ò¿ª"D:\Program Files\Tencent\QQ2009\Bin\QQ.exe"Õâ¸ö³ÌÐò£¬Çó¸ßÈËÖ¸µã¡£»¹ÓпÉÄܵϰÔÚÖ¸¶¨µÄʱ¼ä ......
µ±ÖªµÀÒ»¸öÈÕÆÚ£¬ÈçºÎ°ÑÕâ¸öÈÕÆÚËùÔÚÑ®µÄǰºóÁ½¸öÈÕÆÚÈ¡³ö
±ÈÈçÊäÈë20090905£¬¾ÍÊäÈë20090901 20090910
Êä³ö20090901 20090910
È¡µÃÌìÊýºó×÷Ò»ÏÂÅжÏÔÙ°ÑÕâ¸ö·½·¨ÓÃÏÂvoid set(int field, int value)
......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÎÒÏëÎÒjavaÕâÒ»·½Ãæ·¢Õ¹£¬ÓÐÄÄһλ¸ßÊÖ¿ÉÒÔ¸æËßÎÒ£¬Ïë³ÉΪһÃûJAVA±à³Ì¸ßÊÖ£¬Ëû±ØÐëҪѧϰµÄ֪ʶÂ𣿱ÈÈç˵ÎÒѧÍêÁËJAVAµÄ»ù´¡ÖªÊ¶Ö®ºóÎҸðÑÄ¿¹â·ÅÔÚÄÄÒ»·½Ã棬½ÓÏÂÀ´ÎÒÔÚѧϰÓйØJAVAµÄʲô֪ʶ£¿ÅóÓÑà ......