Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Êý¾ÝÈçºÎ²åÈëµ½SQL SERVER2005

id:×Ô¶¯±àºÅ  name£ºÊéÃû price:µ¥¼Û book_number:±¾Êý
ÏÖÔÚÎÒÏë°ÑpriceºÍbook_number²åÈëµ½Êý¾Ý¿âÖУ¬µ«ÊDz»ÖªµÀÔõô×ö£¬ÏÂÃæÊÇÎÒ²åÈëµ½Êý¾Ý¿âµÄ´úÂëºÍÒª²åÈëµÄÊý¾Ý£¬ÄÄλºÃÐĵĴóÏÀÄܰï°ï棬лл£¡£¡
<%
    Connection con;
    Statement sql;
    ResultSet rs;
    try{
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
    catch(ClassNotFoundException e){out.print("ÀàÕÒ²»µ½!");
    out.print(e);
    }
    try{
    con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433; DatabaseName=book","sa","11011");
    sql=con.createStatement();
    if(request.getParameter("id")==null||(request.getParameter("id").trim()).length()==0)
    {  }//Èç¹ûûÓÐÒª¹ºÂòÊ飬ֻÊDz鿴¹ºÎï³µÖеÄÉÌÆ·  }
    else{
    int id=Integer.parseInt(request.getParameter("id"));
    out.print(" <table border bordercolor=#ccc8888 align=center>");
    out.print(" <tr > <h3> <td colspan=8 align=center bgcolor=#0009999>ÏÂÃæÊÇÄãÑ¡ÔñµÄͼÊé </td> </h3> </tr>");
    out.print(" <tr>");
&


Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

Êý¾Ý´°¿Ú¶¯Ì¬ÐÞ¸ÄSql - PowerBuilder / DataWindow

ΪÁËÂú×ãÊý¾Ý²éѯµÄËÙ¶ÈÎÊÌ⣬ÎÒ½«Ò»ÕÅÊý¾ÝÁ¿´óµÄѧÉú±í°´Äê¶È·Ö³É¶à¸ö±í
students_2008, students_2009È»ºóÎÒÓÖ×öÁËÒ»¸öÄ£°å±ístudents_template,Ä£°å±íÖеÄ×ֶκÍstudents_2008, students_2009Ò»Ñù£¬Ö»²»¹ýÊÇÒ»¸ö ......

Èç¹ûдµÝ¹ésqlÓï¾ä - MS-SQL Server / Ó¦ÓÃʵÀý

ÓÐÁ½¸öͬÑùµÄ±í½á¹¹ 
±í½á¹¹ÈçÏ£º
  id£¨ÐòºÅ£© parentid £¨¸¸½áµãÐòºÅ£© name(½áµãÃû³Æ)
 ±í1 ¼Ç¼ 1 0 aaa
  2 ......

sql ½ØÈ¡×Ö·û´®

ÎÒÒªµÃµ½Ò»¸ö×Ö·û´®È磺
sdfk|||sgts
sdfsfd|||rgreg
wrfw|||sefw
¾ÍÊÇÒªµÃµ½|||ºóÃæµÄ×Ö·û´®£¬ÓÐʲôº¯ÊýÂð£¿ÔõôÓÃÄØ£¿Ð»Ð»£¡
SQL code:
select
right(col,len(col)-charindex('|||',col)-2)
f ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ