²é¿´: 1657  |  »Ø¸´: 9
µ±Ç°Ö»ÏÔʾÂú×ãÖ¸¶¨Ìõ¼þµÄ»ØÌû£¬µã»÷ÕâÀï²é¿´±¾»°ÌâµÄËùÓлØÌû

³þÃ÷¾ê

гæ (СÓÐÃûÆø)

[ÇóÖú] ´ó¼ÒºÃ£¬ÎÒÏÖÔÚÓöµ½ÁËÒ»¸öÎÊÌ⣬Çë´ó¼Ò°ï°ï棡 ÒÑÓÐ1È˲ÎÓë

package Water;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
//import java.util.Scanner;


public class QueryDesc {



        public static List<UserVo> showUser() throws ClassNotFoundException {


                Connection conn = null;
                Statement stmt = null;
                ResultSet rs = null;
                List<UserVo> list = new ArrayList<UserVo>();//ÉùÃ÷Ò»¸öList¼¯ºÏ£¬ÓÃÓÚ´æ·Å²éѯ³öµÄÊý¾Ý

                try {


           // String Str=" SELECT '%s' FROM MONTHAVERAGE ";
                   // String.format(Str,M);          // ¸ñʽ»¯×Ö·û´®


                        conn = JDBC_Connection.getConnection();// Á¬½ÓÊý¾Ý¿â
                        stmt = conn.createStatement();// ½¨Á¢Statement¶ÔÏó;
            rs = stmt.executeQuery("SELECT Ò» FROM MONTHAVERAGE " );

                                while(rs.next())// ½á¹û¼¯´æÔÚ£¬Ôò½øÐÐÑ­»·±éÀú
                                {

                                        UserVo userVo = new UserVo();
                                        userVo.setDD(rs.getInt("Ò»");
                                        list.add(userVo);

                                }

                     }catch (SQLException e) {
                                 // TODO Auto-generated catch block
                                 e.printStackTrace();
                     }finally{
                               JDBC_Connection.free(rs, conn, stmt);// ¹Ø±ÕÁ¬½Ó
                       }
                return list;
        }

´ó¼ÒºÃ£¬ÎÒÏëÖªµÀÔõÑù½« rs = stmt.executeQuery("SELECT Ò» FROM MONTHAVERAGE " );ÕâÒ»¾äÖÐËùÑ¡µÄÄǸöÁÐÃû¡°Ò»¡±±ä³É±äÁ¿£¬ÔÚÒÔÉϵijÌÐòÖÐÎÒÒª¼ÓÈëÒ»¶ÎʲôÑùµÄ´úÂëÀ´ÊµÏÖÄØ£¿Ð»Ð»´ó¼Ò£¡
»Ø¸´´ËÂ¥

» ²ÂÄãϲ»¶

» ±¾Ö÷ÌâÏà¹Ø¼ÛÖµÌùÍÆ¼ö£¬¶ÔÄúͬÑùÓаïÖú:

ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

³þÃ÷¾ê

гæ (СÓÐÃûÆø)

Ëͺ컨һ¶ä
ÒýÓûØÌû:
8Â¥: Originally posted by me_yu at 2014-05-13 16:28:06
public class QueryDesc {
        public static List<UserVo> showUser(String M) throws ClassNotFoundException {
                Connection conn = null;
                Statement stmt = null; ...

ллÄú£¡Ð»Ð»Äú£¡ÕæµÄ´ïµ½Ä¿µÄÁËÒ®£¡
9Â¥2014-05-13 17:34:31
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
²é¿´È«²¿ 10 ¸ö»Ø´ð

me_yu

ľ³æ (ÕýʽдÊÖ)

ΪʲôҪÕâô×öÄØ£¿

[ ·¢×ÔСľ³æ¿Í»§¶Ë ]
Ìý£¬¼Å¾²µÄÒ¹ÀÌïÒ°ÀïÍÜÉùºÍ³æÃù£¬ºÃ²»»¶¿ì£¡
2Â¥2014-05-12 19:20:36
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

libralibra

ÖÁ×ðľ³æ (ÖøÃûдÊÖ)

æôÆï½«¾ü

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

¡ï ¡ï ¡ï ¡ï ¡ï
¸Ðл²ÎÓ룬ӦÖúÖ¸Êý +1
³þÃ÷¾ê: ½ð±Ò+5, ¡ïÓаïÖú, ллÄú£¡ 2014-07-14 10:00:26
CODE:
String name = "--";
String sql_str = "SELECT "+name+" FROM MONTHAVERAGE";
rs = stmt.executeQuery(sql_str);

matlab/VB/python/c++/Javaд³ÌÐòÇë·¢QQÓʼþ:790404545@qq.com
3Â¥2014-05-12 19:23:05
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

³þÃ÷¾ê

гæ (СÓÐÃûÆø)

ÒýÓûØÌû:
2Â¥: Originally posted by me_yu at 2014-05-12 19:20:36
ΪʲôҪÕâô×öÄØ£¿

ÒòΪÎÒÏë¼ÆËã12¸öÔÂÖеÄÈκÎÒ»¸öÔ¶¼ÊÇÓÉÎÒ¿ÉÒÔÕÆ¿ØµÄ¡£¡£
4Â¥2014-05-13 08:28:26
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] 293Çóµ÷¼Á +6 zjlµÄºÅ 2026-03-16 10/500 2026-03-17 13:45 by houyaoxu
[¿¼ÑÐ] 275Çóµ÷¼Á +4 Ì«Ñô»¨ÌìÌ쿪ÐÄ 2026-03-16 4/200 2026-03-17 10:53 by ¹¦·ò·è¿ñ
[¿¼ÑÐ] ²ÄÁÏÓ뻯¹¤304ÇóBÇøµ÷¼Á +7 Çñgl 2026-03-11 8/400 2026-03-17 09:36 by ŬÁ¦Ñ§Ï°×¬²ÊÀñ
[¿¼ÑÐ] 333Çóµ÷¼Á +3 ÎÄ˼¿Í 2026-03-16 7/350 2026-03-16 18:21 by ÎÄ˼¿Í
[¿¼ÑÐ] Áº³ÉΰÀÏʦ¿ÎÌâ×é»¶Ó­ÄãµÄ¼ÓÈë +8 һѼѼӴ 2026-03-14 9/450 2026-03-16 17:35 by ãåÁØ12138
[¿¼ÑÐ] »·¾³¹¤³Ìµ÷¼Á +6 ´ó¿Édigkids 2026-03-16 6/300 2026-03-16 17:16 by barlinike
[¿¼ÑÐ] 326Çóµ÷¼Á +4 ŵ±´¶û»¯Ñ§½±êéê 2026-03-15 7/350 2026-03-16 17:11 by ŵ±´¶û»¯Ñ§½±êéê
[¿¼ÑÐ] 304Çóµ÷¼Á +3 ÂüÊâ2266 2026-03-14 3/150 2026-03-16 16:39 by houyaoxu
[¿¼ÑÐ] 321Çóµ÷¼Á +5 ´óÃ×·¹£¡ 2026-03-15 5/250 2026-03-16 16:33 by houyaoxu
[¿¼ÑÐ] 085600²ÄÁÏÓ뻯¹¤ Çóµ÷¼Á +13 enenenhui 2026-03-13 14/700 2026-03-16 15:19 by ÁËÁËÁËÁË¡£¡£
[¿¼ÑÐ] 0703 ÎïÀí»¯Ñ§µ÷¼Á +3 ÎÒ¿ÉÒÔÉϰ¶µÄ¶Ô 2026-03-13 5/250 2026-03-16 10:50 by ÎÒ¿ÉÒÔÉϰ¶µÄ¶ÔÂ
[¿¼ÑÐ] 326Çóµ÷¼Á +3 mlpqaz03 2026-03-15 3/150 2026-03-16 07:33 by Iveryant
[¿¼ÑÐ] ÇóÀÏʦÊÕÁôµ÷¼Á +4 jiang½ª66 2026-03-14 5/250 2026-03-15 20:11 by Winj1e
[¿¼ÑÐ] Öпƴó²ÄÁÏÓ뻯¹¤319Çóµ÷¼Á +3 ÃÏöβÄÁÏ 2026-03-14 3/150 2026-03-14 20:10 by ms629
[¿¼ÑÐ] Ò»Ö¾Ô¸¹þ¹¤´ó²ÄÁÏ324·ÖÇóµ÷¼Á +5 ãÆÐñ¶« 2026-03-14 5/250 2026-03-14 14:53 by ľ¹Ï¸à
[¿¼ÑÐ] 337Ò»Ö¾Ô¸»ªÄÏÀí¹¤0805²ÄÁÏÇóµ÷¼Á +7 mysdl 2026-03-11 9/450 2026-03-13 22:43 by JourneyLucky
[¿¼ÑÐ] ²ÄÁϹ¤³Ìµ÷¼Á +9 ßäßä¿Õ¿Õ 2026-03-12 9/450 2026-03-13 22:05 by ÐÇ¿ÕÐÇÔÂ
[¿¼ÑÐ] ²ÄÁÏÓ뻯¹¤085600µ÷¼ÁÇóÀÏʦÊÕÁô +9 jiaanl 2026-03-11 9/450 2026-03-13 20:22 by JourneyLucky
[¿¼ÑÐ] ¹¤¿Æ0856ר˶»¯Ñ§¹¤³Ì269Äܵ÷¼ÁÂð +10 ÎÒÏë¶ÁÑÐ11 2026-03-10 10/500 2026-03-13 10:14 by Yuyi.
[¿¼ÑÐ] 283Çóµ÷¼Á£¬²ÄÁÏ¡¢»¯¹¤½Ô¿É +8 ËÕ´òË®7777 2026-03-11 10/500 2026-03-13 09:06 by Linda Hu
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û