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

jspÖÐsqlǶÌײéѯµÄÎÊÌâ - Web ¿ª·¢ / JavaScript

ÓÐÁ½ÕÅ±í£º
tb_topic (Tid,U_id,T_title,T_content,T_submittime,T_rq);Ö÷¼ü£ºU_id¡£T_rqÊǸÃÖ÷ÌâµÄ»Ø¸´Êý¡£
tb_response(Rid,Tid,R_author,R_submittime,R_content);Ö÷¼üÊÇ£ºRid¡£
ÏëʵÏÖÒ»¸öÑ­»·Í³¼ÆÊä³ö¡£¸ù¾ÝTid´Ó±ítb_responseÖлñµÃËùÓлظ´¹ýtb_topicÖеÄÖ÷ÌâµÄÓû§ÃûR_author£¬
ÔÙ¸ù¾ÝR_author»ñµÃ¸ÃÓû§ÔÚtb_topicÖз¢±íµÄÌû×ÓÊýºÍ»Ø¸´´óÓÚ10µÄÌû×ÓÊý¡£¿ÉÒ»Ö±Ìáʾwhile(rs.next())ÕâÐÐÓдíÎó£¬Çë¸ßÊÖÖ¸µãÃÔ½ò°¡¡£

ÏÂÃæÊÇÎҵĴúÂ룺£¨Tid´ÓÇ°ÃæµÄÒ³Ãæ»ñÈ¡£©
<%@ page contentType="text/html;charset=GB2312"%>
<%@ page import="java.sql.*" %>

<% String Tid=request.getParameter("Tid");
  Connection con;
Statement sql; 
ResultSet rs; 
ResultSet rs2; 
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jfreechart";
String user="sa";
String passwd="123456";
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");  
con=java.sql.DriverManager.getConnection(url,user,passwd);
sql = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String follower="select R_author from tb_response where Tid='"+Tid+"' order by Tid";
  rs=sql.executeQuery(follower);
while(rs.next())
{
String nub2="select T_rq from tb_topic


Ïà¹ØÎÊ´ð£º

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

tomcat»·¾³ÏÂjsp±àÒë´íÎó£¬Çó½â£¡ - Java / Web ¿ª·¢

org.apache.jasper.JasperException: Unable to compile class for JSP: 
An error occurred at line: 52 in the jsp file: /vip_info.jsp
ÕË cannot be resolved
49: <table border="1& ......

SQL·ÖÒ³ÓëOracle·ÖÒ³µÄÒÉÎÊ£¿ - Java / Web ¿ª·¢

ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ã棬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......

ASPÒ³ÃæÎÞ·¨´ò¿ªÇóÖú£¡ - MS-SQL Server / »ù´¡Àà

¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ