Êý¾ÝÈçºÎ²åÈëµ½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>");
&
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
ΪÁËÂú×ãÊý¾Ý²éѯµÄËÙ¶ÈÎÊÌ⣬ÎÒ½«Ò»ÕÅÊý¾ÝÁ¿´óµÄѧÉú±í°´Äê¶È·Ö³É¶à¸ö±í
students_2008, students_2009È»ºóÎÒÓÖ×öÁËÒ»¸öÄ£°å±ístudents_template,Ä£°å±íÖеÄ×ֶκÍstudents_2008, students_2009Ò»Ñù£¬Ö»²»¹ýÊÇÒ»¸ö ......
ÓÐÁ½¸öͬÑùµÄ±í½á¹¹
±í½á¹¹ÈçÏ£º
id£¨ÐòºÅ£© parentid £¨¸¸½áµãÐòºÅ£© name(½áµãÃû³Æ)
±í1 ¼Ç¼ 1 0 aaa
2 ......
ÎÒÒªµÃµ½Ò»¸ö×Ö·û´®È磺
sdfk|||sgts
sdfsfd|||rgreg
wrfw|||sefw
¾ÍÊÇÒªµÃµ½|||ºóÃæµÄ×Ö·û´®£¬ÓÐʲôº¯ÊýÂð£¿ÔõôÓÃÄØ£¿Ð»Ð»£¡
SQL code:
select
right(col,len(col)-charindex('|||',col)-2)
f ......