Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿ - MS-SQL Server / »ù´¡Àà

Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ

¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿

Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ

º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£

sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......

C# SQL µÄUPDATETEXT ÎÊÌâ - .NET¼¼Êõ / C#

A±í ÓÐÁ½¸ö×ֶΠ
  id ΨһÊý×ÖÓò
  InfoTxt text ÀàÐÍ
 ÎÒÏÖÔÚÒª°Ñ id ²»ÊÇ14 µÄËùÓÐ InfoTxt×Ö¶Î Îı¾ºóÃæ ¶¼¼ÓÉÏ 'aaa' 
°´ÏÂÃæÖ´ÐÐÏÂÀ´ Ö»Óбí×îºóÒ»ÐмÓÉÏÁË 'aaa' ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ