16£®±íµ¥Ìá½»ºó£¬¶¯×÷Ö¸Áî²Å»áÖ´ÐС££¨¶Ô£©
Èý¡¢Ìî¿ÕÌâ
1£®ÔÚWeb·þÎñÆ÷¶ËʹÓÃJavaBean£¬½«ÔÀ´Ò³ÃæÖгÌÐòƬÍê³ÉµÄ¹¦ÄÜ·â×°µ½JavaBeanÖУ¬ÕâÑùÄܺܺõØÊµÏÖ ÒµÎñÂß¼²ãÓëÊÓͼ²ãµÄ·ÖÀë¡£ 2£®JavaBeanÖÐÓÃÒ»×éset·½·¨ÉèÖÃBeanµÄ˽ÓÐÊôÐÔÖµ£¬get·½·¨»ñµÃBeanµÄ˽ÓÐÊôÐÔÖµ¡£setºÍget·½·¨Ãû³ÆÓëÊôÐÔÃû³ÆÖ®¼ä±ØÐë¶ÔÓ¦£¬Ò²¾ÍÊÇ£ºÈç¹ûÊôÐÔÃû³ÆÎªxxx£¬ÄÇôsetºÍget·½·¨µÄÃû³Æ±ØÐëΪ setXxx() ºÍ getXxx() ¡£ 3£®Óû§ÔÚʵ¼ÊWebÓ¦Óÿª·¢ÖУ¬±àдBean³ýÁËҪʹÓÃimportÓï¾äÒýÈëJavaµÄ±ê×¼À࣬¿ÉÄÜ»¹ÐèÒª×Ô¼º±àдµÄÆäËûÀà¡£Óû§×Ô¼º±àдµÄ±»BeanÒýÓõÄÀà³ÆÖ®Îª BeanµÄ¸¨ÖúÀà ¡£
4£®´´½¨JavaBeanµÄ¹ý³ÌºÍ±àдJavaÀàµÄ¹ý³Ì»ù±¾ÏàËÆ£¬¿ÉÒÔÔÚÈκÎJavaµÄ±à³Ì»·¾³ÏÂÍê³É ±àд¡¢±àÒëºÍ·¢²¼ ¡£ 5£®²¼ÖÃJavaBeanÒªÔÚWeb·þÎñĿ¼µÄWEB-INF\\classesÎļþ¼ÐÖн¨Á¢Óë BeanµÄ°üÃû ¶ÔÓ¦µÄ×ÓĿ¼£¬Óû§Òª×¢ÒâĿ¼Ãû³ÆµÄ´óСд¡£ 6£®Ê¹ÓÃBeanÊ×ÏÈÒªÔÚJSPÒ³ÃæÖÐʹÓà import Ö¸ÁBeanÒýÈë¡£
7£®ÒªÏëÔÚJSPÒ³ÃæÖÐʹÓÃBean£¬±ØÐëÊ×ÏÈʹÓà ¶¯×÷±ê¼ÇÔÚÒ³ÃæÖж¨ÒåÒ»¸öJavaBeanµÄʵÀý¡£ 8£®scopeÊôÐÔ´ú±íÁËJavaBeanµÄ×÷Ó÷¶Î§£¬Ëü¿ÉÒÔÊÇpage¡¢ request ¡¢sessionºÍapplicationËĸö×÷Ó÷¶Î§ÖеÄÒ»ÖÖ¡£
ËÄ¡¢Ë¼¿¼Ìâ
1£®JavaBeanºÍÒ»°ãÒâÒåÉϵÄJavaÀàÓкÎÇø±ð£¿ 2£®¼òÊöÖµBeanµÄ±àд·½·¨£¬ÓÐÄÄЩעÒâµã£¿
3£®ÈçºÎʵÏÖÒ»¸öBeanµÄÊôÐÔÓë±íµ¥²ÎÊýµÄ¹ØÁª£¿ 4£®ÈçºÎÔÚÒ³ÃæµÄ³ÌÐòƬÖÐʹÓÃBean£¿
5£®ÊÔÊörequest¡¢sessionºÍapplicationÓÐЧ·¶Î§µÄBeanÉúÃüÖÜÆÚ£¿
µÚÁùÕ Îļþ·ÃÎÊ
Ò»¡¢Ñ¡ÔñÌâ
1£®JavaÌṩµÄÁ÷À࣬´Ó¹¦ÄÜÉÏ¿´½«Êý¾ÝдÈëÎļþµÄÁ÷³ÆÎª£¨ B £© A£©ÊäÈëÁ÷ B£©Êä³öÁ÷ C£©×Ö·ûÁ÷ D£©×Ö½ÚÁ÷ 2£®JavaÌṩµÄÁ÷À࣬´ÓËù²Ù×÷µÄÊý¾Ýµ¥Î»À´¿´½«Êý¾ÝдÈëÎı¾ÎļþµÄÁ÷³ÆÎª£¨ C £© A£©ÊäÈëÁ÷ B£©Êä³öÁ÷ C£©×Ö·ûÁ÷ D£©×Ö½ÚÁ÷
3£®ÏÂÁÐFile¶ÔÏóµÄÄĸö·½·¨Äܹ»Åжϸø¶¨Â·¾¶ÏµÄÎļþÊÇ·ñ´æÔÚ¡££¨ C £© A£©canRead() B£©canWrite() C£©exists() D£©isDirectory() 4£®ÏÂÁÐFile¶ÔÏóµÄÄĸö·½·¨Äܹ»ÅжÏÓ¦ÓóÌÐòÄÜ·ñ¶ÁÈ¡¸ø¶¨Â·¾¶ÏµÄÎļþ¶ÔÏó¡££¨ A £©
A£©canRead() B£©canWrite() C£©exists() D£©isDirectory()
5£®ÏÂÁÐFile¶ÔÏóµÄÄĸö·½·¨Äܹ»ÅжÏÓ¦ÓóÌÐòÄÜ·ñÏò¸ø¶¨Â·¾¶ÏµÄÎļþ¶ÔÏóдÈëÊý¾Ý¡££¨ B £©
A£©canRead() B£©canWrite() C£©exists() D£©isDirectory()
6£®ÏÂÁÐFile¶ÔÏóµÄÄĸö·½·¨Äܹ»ÅжÏFile¶ÔÏó¶ÔÓ¦µÄ·¾¶ÊÇ·ñΪĿ¼¡££¨ D £© A£©canRead() B£©canWrite() C£©exists() D£©isDirectory()
7£®ÏÂÁÐFile¶ÔÏóµÄÄĸö·½·¨Äܹ»ÅжÏFile¶ÔÏó¶ÔÓ¦µÄ·¾¶ÊÇ·ñΪÎļþ¡££¨ A £© A£©isFile() B£©createNewFile() C£©lastModified() D£©length()
8£®ÏÂÁÐFile¶ÔÏóµÄÄĸö·½·¨Äܹ»´´½¨Ò»¸öÐÂÎļþ£¬Èç¹û´´½¨³É¹¦·µ»Øtrue£¬·ñÔò·µ»Øfalse£¨¸ÃÎļþÒѾ´æÔÚ£©¡££¨ B £© A£©isFile() B£©createNewFile() C£©mikdir() D£©length()
9£®ÏÂÁÐFile¶ÔÏóµÄÄĸö·½·¨Äܹ»´´½¨File¶ÔÏó¶ÔÓ¦µÄ·¾¶£¬Èç¹û´´½¨³É¹¦·µ»Øtrue£¬·ñÔò·µ»Øfalse£¨¸ÃĿ¼ÒѾ´æÔÚ£©£¨ C £© A£©isFile() B£©createNewFile() C£©mikdir() D£©length()
10£®ÏÂÃæÊÇFileInputStream¶ÁÈ¡ÎļþµÄ´úÂëÆ¬¶Î£º File file1=new File(fileName);
FileInputStream finput=new FileInputStream(file1); int size=finput.available();
BufferedInputStream buffer1=new BufferedInputStream(finput); byte b[]=new byte[90]; int n=0; while((n=buffer1.read(b))!=-1){ allFilesmess.append(new String(b,0,n));
} buffer1.close(); finput.close();
³ý×îºóÒ»´ÎÍ⣬´úÂëÖÐbuffer1.read(b)ÿ´Î¶ÁÈ¡ÎļþµÄ×Ö½ÚÊý£¿£¨A£© A£©90 B£©89 C£©n D£©size/n
11£®ÏÂÃæÊÇFileOutputStream¶ÔÏóдÈëµÄ´úÂëÆ¬¶Î£º String filesMess=¡±abcdef¡±; FileOutputStream outf=new FileOutputStream(fileName); BufferedOutputStream bufferout= new BufferedOutputStream(outf); byte b[]=this.filesMess.getBytes(); bufferout.write(b); bufferout.flush(); bufferout.close(); outf.close();
´úÂëÖ´Ðкó£¬ÎļþÖлáдÈëÄĸö×Ö·û´®µÄ×Ö½ÚÂ루B £© A£©¡±filesMess¡± B£©¡±abcdef¡± C£©¡±b¡± D£©²»È·¶¨
12£®ÏÂÃæÊÇFileReader¶ÔÏó¶ÁÈ¡Îı¾ÎļþµÄ´úÂëÆ¬¶Î£º StringBuffer temp=new StringBuffer(); if(fileName!=null){ String strTemp=null; FileReader fr=new FileReader(fileName); BufferedReader buffer1=new BufferedReader(fr); while((strTemp=buffer1.readLine())!=null){ byte bb[]=strTemp.getBytes(); strTemp=new String(bb); temp.append(\ } allFilesmess=\ buffer1.close(); fr.close();
´úÂëÖÐbuffer¡£readLine()ÿ´Î¶ÁÈ¡ÎļþµÄ×Ö·ûÊý£¿£¨D£© A£©Ò»¸ö×Ö·û B£©Ò»ÐÐ×Ö·û°üÀ¨»»Ðзû
C£©bb.length¸ö D£©Ò»ÐÐ×Ö·û²»°üÀ¨»»ÐÐ×Ö·û
13£®BufferedReader´¦ÀíReaderÀàÖеķ½·¨Í⣬»¹ÌṩÁËpublic String readLine()·½·¨£¬¸Ã·½·¨¶ÁÈëÒ»ÐÐÎı¾£¬ÕâÀïµÄ¡°Ò»ÐС±Ö¸×Ö·û´®ÒÔ¡°\\n¡±»òʲô×ö½áβ¡££¨£©
A£©\\t B£©\\f C£©\\r D£©\\p
¶þ¡¢ÅжÏÌâ
1£®Ê¹ÓÃJavaµÄÊäÈëÁ÷¶ÁÈ¡Êý¾ÝµÄʱºò£¬¾Í»á¿ªÆôÒ»¸öͨÏòÊý¾ÝÔ´µÄͨµÀ£¬Õâ¸öÊý¾ÝÔ´¿ÉÒÔÊÇÎļþ£¬Äڴ棬»òÊÇÍøÂçÁ¬½ÓµÈ¡££¨¶Ô£©
2£®Ê¹ÓÃJavaµÄÊä³öÁ÷дÈëÊý¾ÝµÄʱºò£¬¾Í»á¿ªÆôÒ»¸öͨÏòÄ¿µÄµØµÄͨµÀ£¬Õâ¸öÄ¿µÄµØ¿ÉÒÔÊÇÎļþ£¬µ«²»ÄÜÊÇÄÚ´æ»òÍøÂçÁ¬½ÓµÈ¡££¨´í£© 3£®×Ö½ÚÁ÷Ò»°ãÊÇÓÃÀ´¶ÁÈë»òд³ö¶þ½øÖÆÊý¾Ý¡££¨¶Ô£©
4£®¡°´¿Îı¾¡±ÀàµÄÐÅÏ¢£¬Ò»°ãʹÓÃ×Ö·ûÁ÷À´½øÐд¦Àí¡££¨¶Ô£©
5£®´´½¨Ò»¸öFile¶ÔÏ󣬾ͻáÔÚij¸öÎïÀí·¾¶Ï´´½¨Ò»¸öÎļþ»òĿ¼¡££¨´í£© 6£®FileÀàÖ±½Ó´¦ÀíÎļþºÍÎļþϵͳ£¬Ëü²¢²»Éæ¼°ÎļþµÄ¶Áд²Ù×÷¡££¨¶Ô£©
7£®Java³ÌÐòÒ»°ãÓÃ×Ö·ûÁ÷´¦Àí¶þ½øÖÆ×Ö½Ú¶ÔÏó£¬ÓÃ×Ö½ÚÁ÷´¦Àí×Ö·û»ò×Ö·û´®¶ÔÏó¡££¨´í£© 8£®InputStream³éÏóÀàµÄread·½·¨³ö´íºóÒ»¶¨»áÅ׳öÒ»¸öIOExceptionÒì³£¡££¨¶Ô£© 9£®OutputStream³éÏóÀàµÄwrite·½·¨³ö´íºóÒ»Ò»¶¨»áÅ׳öÒ»¸öIOExcetptionÒì³£¡££¨¶Ô£©
10£®BufferedReaderÌṩÁËpublic String readLine()·½·¨£¬¸Ã·½·¨´ÓÎļþÖжÁÈëÒ»ÐÐÎı¾£¬Èç¹ûÒѵ½´ïÁ÷½áβ¶øÎ´¶ÁÈëÈκÎÎÄ×Ö£¬Ôò·µ»Ø-1¡££¨´í£©
11£®RandomAccessFileÀ༴²»ÊÇÊäÈëÁ÷ÀàInputSteamµÄ×ÓÀ࣬Ҳ²»ÊÇÊä³öÁ÷ÀàOutputStreamµÄ×ÓÀ࣬µ«ËüͬʱʵÏÖÁËDataInputºÍDataOutput½Ó¿Ú¡££¨¶Ô£© 12£®Ê¹ÓÃRandomAccessFileÀà·ÃÎÊÎļþµÄ³ÌÐò£¬²»¿ÉÒÔËæÒâ¸Ä±äÎļþÖ¸ÕëλÖᣣ¨´í£©
Èý¡¢Ìî¿ÕÌâ
1£®JavaÖÐÓÐËĸö¡°ÊäÈë/Êä³ö¡±µÄ³éÏóÀ࣬InputStream¡¢ OutputStream ¡¢ReaderºÍ Writer ¡£ InputStream ºÍ OutputStream ÓÃÓÚ×ö×Ö½ÚÁ÷ÊäÈëÊä³ö²Ù×÷£¬ Reader ºÍ Writer ÓÃÓÚ×ö×Ö·ûÁ÷ÊäÈëÊä³ö²Ù×÷¡£ 2£®°´ÕÕHTTPÐÒéµÄ¹æ¶¨£¬ÉÏ´«µÄÁÙʱÎļþ µÚ¶þ ÐÐÓÐÉÏ´«ÎļþµÄÎļþÃûÐÅÏ¢£¬µÚËÄ ÐнáÊøÎ»Öõ½µ¹Êý µÚÁù ÐнáÊøÎ»ÖÃÖ®¼äµÄÄÚÈÝÊÇÎļþ±¾Éí²¿·Ö¡£ 3£®response¶ÔÏóµÄ setContentType() ÓÃÀ´¶¨Òå·þÎñÆ÷·¢Ë͸ø¿Í»§¶ËµÄMIMEÀàÐÍ¡£ 4£® WordÎļþ µÄMIMEÀàÐÍÊÇ¡°application/msword¡±, ExcelÎļþ µÄMIMEÀàÐÍÊÇ¡°application/msexcel¡±¡£
ËÄ¡¢Ë¼¿¼Ìâ
1£®×Ö½ÚÁ÷ºÍ×Ö·ûÁ÷ÓкÎÇø±ð£¿
2£®BufferedInputStreamÓëFileInputStreamÈçºÎÅäºÏʹÓã¿ 3£®BufferedOutputStreamÓëFileOutputStreamÈçºÎÅäºÏʹÓã¿ 4£®BufferedReaderÓëFileReaderÈçºÎÅäºÏʹÓã¿ 5£®BufferedWriterÓëFileWriterÈçºÎÅäºÏʹÓã¿ 6£®RandomAccessFile·ÃÎÊÎļþÓкÎÌØµã£¿ 7£®ÈçºÎ´¦ÀíÎļþ¶Áд²Ù×÷Öз¢ÉúµÄÒì³££¿
µÚÆßÕ Êý¾Ý¿â·ÃÎÊ
Ò»¡¢Ñ¡ÔñÌâ 1£®ÏÂÃæÄÄÒ»Ïî²»ÊÇJDBCµÄ¹¤×÷ÈÎÎñ£¿£¨C£©
A£©ÓëÊý¾Ý¿â½¨Á¢Á¬½Ó B£©²Ù×÷Êý¾Ý¿â£¬´¦ÀíÊý¾Ý¿â·µ»ØµÄ½á¹û C£©ÔÚÍøÒ³ÖÐÉú³É±í¸ñ D£©ÏòÊý¾Ý¿â¹ÜÀíϵͳ·¢ËÍSQLÓï¾ä 2£®ÏÂÃæÄÄÒ»Ïî²»ÊǼÓÔØÇý¶¯³ÌÐòµÄ·½·¨£¿£¨A£©
A£©Í¨¹ýDriverManager.getConnection·½·¨¼ÓÔØ B£©µ÷Ó÷½·¨ Class.forName
C£©Í¨¹ýÌí¼ÓϵͳµÄjdbc.driversÊôÐÔ D£©Í¨¹ýregisterDriver·½·¨×¢²á
3£®¹ØÓÚ·ÖÒ³ÏÔʾ£¬ÏÂÁеÄÐðÊöÄÄÒ»ÏîÊDz»ÕýÈ·µÄ£¿£¨A£©
A£©Ö»±àÖÆÒ»¸öÒ³ÃæÊDz»¿ÉÄÜʵÏÖ·ÖÒ³ÏÔʾµÄ B£©²ÉÓÃÒ»ÖÁÈý¸öÒ³Ãæ¶¼¿ÉÒÔʵÏÖ·ÖÒ³ÏÔʾ
C£©·ÖÒ³ÏÔʾÖУ¬¼Ç¼¼¯²»±ØÔÚÒ³ÃæÌø×ªºóÖØÐÂÉú³É D£©·ÖÒ³ÏÔʾÖÐÒ³ÃæÏÔʾµÄ¼Ç¼Êý¿ÉÒÔËæÓû§ÊäÈëµ÷Õû
4£®ÔÚ½¨Á¢JSPÍøÕ¾Ä¿Â¼Ê±ÐèÒª×ñÑһЩ¹æÔò£¬ÒÔϹæÔò´íÎóµÄÊÇ£º£¨B£©
A£©Ã¿¸öÖ÷ÒªÀ¸Ä¿¿ªÉèÒ»¸öÏàÓ¦µÄ×ÓĿ¼
B£©ËùÓÐflash, avi, ram, quicktime µÈ¶àýÌåÎļþ´æ·ÅÔÚ¸ùĿ¼Ï C£©¸ùĿ¼һ°ãÖ»´æ·Åindex.htmÒÔ¼°ÆäËû±ØÐëµÄϵͳÎļþ D£©Ä¿Â¼½¨Á¢Ó¦ÒÔ×îÉٵIJã´ÎÌṩ×îÇåÎú¼ò±ãµÄ·ÃÎʽṹ
5£®Èç¹û½«E£º\\MyWeb×÷ΪJSPÍøÕ¾Ä¿Â¼£¬ÐèÒªÐÞ¸ÄÄĸöÎĵµ£¿£¨A£©
A£©server.xml B£©server.htm C£©index.xml D£©index.htm 6£®DriverManagerÀàµÄgetConnection(String url,String user,String password)·½·¨ÖУ¬²ÎÊýurlµÄ¸ñʽΪjdbc:<×ÓÐÒé>:<×ÓÃû³Æ>£¬ÏÂÁÐÄĸöurlÊDz»ÕýÈ·µÄ£¿£¨A£© A£©¡±jdbc:mysql://localhost:80/Êý¾Ý¿âÃû¡± B£©¡±jdbc:odbc:Êý¾ÝÔ´¡±
C£©¡±jdbc:oracle:thin@host£º¶Ë¿ÚºÅ£ºÊý¾Ý¿âÃû¡±
D£©¡±jdbc:sqlserver://172.0.0.1:1443;DatabaseName=Êý¾Ý¿âÃû¡± 7£®ÔÚJDBCÖУ¬ÏÂÁÐÄĸö½Ó¿Ú²»Äܱ»Connection´´½¨£¨D£©¡£
A£©Statement B£©PreparedStatement C£©CallableStatement D£©RowsetStatement 8£®ÏÂÃæÊǼÓÔØJDBCÊý¾Ý¿âÇý¶¯µÄ´úÂëÆ¬¶Î£º
try{
Class.forName(\ }
catch(ClassNotFoundException e){ out.print(e); }
¸Ã³ÌÐò¼ÓÔØµÄÊÇÄĸöÇý¶¯£¿£¨£©
A£©JDBC-ODBCÇÅÁ¬½ÓÇý¶¯ B£©²¿·ÖJava±àд±¾µØÇý¶¯ C£©±¾µØÐÒé´¿JavaÇý¶¯ D£©ÍøÂç´¿JavaÇý¶¯
9£®ÏÂÃæÊÇ´´½¨Statement½Ó¿Ú²¢Ö´ÐÐexecuteUpdate·½·¨µÄ´úÂëÆ¬¶Î£º conn=DriverManager.getConnection(\ stmt=conn.createStatement();
String strsql=\Àî','Ç廪³ö°æÉç',35)\ n=stmt.executeUpdate(strsql);
´úÂëÖ´Ðгɹ¦ºónµÄֵΪ £¨A£©¡£
A£©1 B£©0 C£©-1 D£©Ò»¸öÕûÊý
10£®ÏÂÁдúÂëÖÐrsΪ²éѯµÃµ½µÄ½á¹û¼¯£¬´úÂëÔËÐкó±í¸ñµÄÿһÐÐÓм¸¸öµ¥Ôª¸ñ£¨B £©
while(rs.next()){ out.print(\
out.print(\ out.print(\ out.print(\
out.print(\ out.print(\ out.print(\ }
A£©4 B£©5 C£©6 D£©²»È·¶¨
11£®ÏÂÃæÄĸöÃüÁî×éºÏÄܹ»Æô¶¯mysqlÊý¾Ý¿â·þÎñ£¨ A £©
A£© B£© C£©6 D£© mysqld-nt e: use book start cd mysql cd bin Mysql -u root
12£®ÏÂÃæÄĸöÃüÁî×éºÏÄܹ»´ò¿ªmysqlÊý¾Ý¿â¼àÊÓ´°¿Ú£¨ B £©
A£© B£© C£©6 D£© mysqld-nt e: use book start cd mysql cd bin Mysql -u root
13£®ÏÂÃæµÄ´úÂëÊÇÁ¬½ÓÄĸöÊý¾Ý¿âµÄÇý¶¯¼ÓÔØÆ¬¶Î£¨ A £© try{
Class.forName(\ }
catch(Exception e){
out.print(e.toString()); }
A£©Oracle B£©Sql Server C£©MySql D£©²»È·¶¨
14£®ÏÂÃæµÄ´úÂëÊÇÁ¬½ÓÄĸöÊý¾Ý¿âµÄÇý¶¯¼ÓÔØÆ¬¶Î£¨ B £© try{
Class.forName(\ }
catch(Exception e){
out.print(e.toString()); }
A£©Oracle B£©Sql Server C£©MySql D£©²»È·¶¨ 15£®²éѯ½á¹û¼¯ResultSet¶ÔÏóÊÇÒÔͳһµÄÐÐÁÐÐÎʽ×éÖ¯Êý¾ÝµÄ£¬Ö´ÐÐResultSet rs = stmt.executeQuery (\Óï¾ä£¬µÃµ½µÄ½á¹û¼¯rsµÄÁÐÊýΪ£¨ B £© A£©4 B£©5
C£©6 D£©²»È·¶¨ 16£®ÏÂÁдúÂëÉú³ÉÁËÒ»¸ö½á¹û¼¯
conn=DriverManager.getConnection(uri,user,password);
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(\ÏÂÃæÄÄÏî¶Ô¸ÃrsÃèÊöÕýÈ·µÄÊÇ£¨B£©
A£©Ö»ÄÜÏòÏÂÒÆ¶¯µÄ½á¹û¼¯ B£©¿ÉÉÏϹö¶¯µÄ½á¹û¼¯ C£©Ö»ÄÜÏòÉÏÒÆ¶¯µÄ½á¹û¼¯ D£©²»È·¶¨ÊÇ·ñ¿ÉÒÔ¹ö¶¯ 17£®ÏÂÁдúÂëÉú³ÉÁËÒ»¸ö½á¹û¼¯
conn=DriverManager.getConnection(uri,user,password);
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(\ÏÂÃæÄÄÏî¶Ô¸ÃrsÃèÊöÕýÈ·£¨ A £©
A£©²»ÄÜÓýá¹û¼¯ÖеÄÊý¾Ý¸üÐÂÊý¾Ý¿âÖеıí B£©ÄÜÓýá¹û¼¯ÖеÄÊý¾Ý¸üÐÂÊý¾Ý¿âÖеıí C£©Ö´ÐÐupdate·½·¨ÄܸüÐÂÊý¾Ý¿âÖеıí D£©²»È·¶¨
18£®ÏÂÁдúÂëÉú³ÉÁËÒ»¸ö½á¹û¼¯
conn=DriverManager.getConnection(uri,user,password);
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(\ÏÂÃæÄÄÏî¶Ô¸ÃrsÃèÊöÕýÈ·£¨ B £©
A£©Êý¾Ý¿âÖбíÊý¾Ý±ä»¯Ê±½á¹û¼¯ÖÐÊý¾Ý²»±ä
B£©Êý¾Ý¿âÖбíÊý¾Ý±ä»¯Ê±½á¹û¼¯ÖÐÊý¾Ýͬ²½¸üРC£©Ö´ÐÐupdate·½·¨ÄÜÓëÊý¾Ý¿âÖбíµÄÊý¾Ýͬ²½¸üРD£©²»È·¶¨
19£®ÏÂÁдúÂëÉú³ÉÁËÒ»¸ö½á¹û¼¯
conn=DriverManager.getConnection(uri,user,password);
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(\rs.first();
ÏÂÃæÄÄÏî¶Ô¸ÃrsÃèÊöÕýÈ·£¨A£© A£©rs.isFirst()ÎªÕæ B£©rs.ifLast()ÎªÕæ
C£©rs.isAfterLast()ÎªÕæ D£©rs.isBeforeFirst()ÎªÕæ 21£®ÏÂÁдúÂëÉú³ÉÁËÒ»¸ö½á¹û¼¯
conn=DriverManager.getConnection(uri,user,password);
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(\rs.first();rs. previous();
ÏÂÃæÄÄÏî¶Ô¸ÃrsÃèÊöÕýÈ·£¨D£© A£©rs.isFirst()ÎªÕæ B£©rs.ifLast()ÎªÕæ
C£©rs.isAfterLast()ÎªÕæ D£©rs.isBeforeFirst()ÎªÕæ 21£®ÏÂÁдúÂëÉú³ÉÁËÒ»¸ö½á¹û¼¯
conn=DriverManager.getConnection(uri,user,password);
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(\rs.last();rs.next();
ÏÂÃæÄÄÏî¶Ô¸ÃrsÃèÊöÕýÈ·£¨C£© A£©rs.isFirst()ÎªÕæ B£©rs.ifLast()ÎªÕæ
C£©rs.isAfterLast()ÎªÕæ D£©rs.isBeforeFirst()ÎªÕæ
22£®¸ø³öÁËÈçϵIJéѯÌõ¼þ×Ö·û´®String condition=\ÏÂÁÐÄĸö½Ó¿ÚÊʺÏÖ´ÐиÃSQL²éѯ£¨B£© A£©Statement
B£©PrepareStatement C£©CallableStatement D£©²»È·¶¨
¶þ¡¢ÅжÏÌâ
1£®JDBC¹¹½¨ÔÚODBC»ù´¡ÉÏ£¬ÎªÊý¾Ý¿âÓ¦Óÿª·¢ÈËÔ±¡¢Êý¾Ý¿âǰ̨¹¤¾ß¿ª·¢ÈËÔ±ÌṩÁËÒ»ÖÖ±ê×¼£¬Ê¹¿ª·¢ÈËÔ±¿ÉÒÔÓÃÈκÎÓïÑÔ±àдÍêÕûµÄÊý¾Ý¿âÓ¦ÓóÌÐò¡££¨´í£©
2£®Êý¾Ý¿â·þÎñÓëWeb·þÎñÆ÷ÐèÒªÔÚͬһ̨¼ÆËã»úÉÏ¡££¨´í£©
3£®JDBC¼ÓÔØ²»Í¬Êý¾Ý¿âµÄÇý¶¯³ÌÐò£¬Ê¹ÓÃÏàÓ¦µÄ²ÎÊý¿ÉÒÔ½¨Á¢Óë¸÷ÖÖÊý¾Ý¿âµÄÁ¬½Ó¡££¨¶Ô£©
4£®Connection.createStatement()²»´ø²ÎÊý´´½¨Statement¶ÔÏ󣬲»Äܹ»À´»ØµÄ¹ö¶¯¶ÁÈ¡½á¹û¼¯¡££¨¶Ô£©
5£®Ê¹ÓÃÊý¾Ý¿âÁ¬½Ó³ØÐèÒª·³ËöµÄÅäÖã¬Ò»°ã²»ÒËʹÓᣣ¨´í£©
6£®Ó¦ÓóÌÐò·ÖÒ³ÏÔʾ¼Ç¼¼¯Ê±£¬²»ÒËÔÚÿҳ¶¼ÖØÐÂÁ¬½ÓºÍ´ò¿ªÊý¾Ý¿â¡££¨¶Ô £© 7£®JDBCÖеÄURLÌṩÁËÒ»ÖÖ±êʶÊý¾Ý¿âµÄ·½·¨£¬Ê¹DriverManageÀàÄܹ»Ê¶±ðÏàÓ¦µÄÇý¶¯³ÌÐò¡££¨¶Ô£© 8£®Óû§·¢²¼WebÓ¦ÓóÌÐò£¬±ØÐëÐÞ¸Ä%TOMCAT_HOME%\\conf\\server.xmlÎļþ¡££¨¶Ô£©
9£®½øÐзÖÒ³£¬¿Éµ÷ÓÃJDBCµÄ¹æ·¶ÖÐÓйطÖÒ³µÄ½Ó¿Ú¡££¨´í£©
10£®JDBCµÄURL×Ö·û´®ÊÇÓÉÇý¶¯³ÌÐòµÄ±àдÕßÌṩµÄ£¬²¢·ÇÓɸÃÇý¶¯³ÌÐòµÄʹÓÃÕßÖ¸¶¨¡££¨¶Ô£© 11£®ResultSet½á¹û¼¯£¬Ã¿Ò»´Îrs¿ÉÒÔ¿´µ½Ò»ÐУ¬ÒªÔÚ¿´µ½ÏÂÒ»ÐУ¬±ØÐëʹÓÃnext()·½·¨Òƶ¯µ±Ç°ÐС££¨´í£©
12£®Èç¹ûÐèÒªÔÚ½á¹û¼¯ÖÐǰºóÒÆ¶¯»òËæ»úÏÔʾijһÌõ¼Ç¼£¬Õâʱ¾Í±ØÐëµÃµ½Ò»¸ö¿ÉÒÔ¹ö¶¯µÄ½á¹û¼¯¡££¨¶Ô£©
13£®Statement¶ÔÏóÌṩÁËint executeUpdate(String sqlStatement)·½·¨£¬ÓÃÓÚʵÏÖ¶ÔÊý¾Ý¿âÖÐÊý¾ÝµÄÌí¼Ó¡¢É¾³ýºÍ¸üвÙ×÷¡££¨¶Ô£©
14£®Statement¶ÔÏóµÄexecuteUpdate(String sqlStatement)·½·¨ÖУ¬sqlStatement²ÎÊýÊÇÓÉinsert¡¢deleteºÍupdateµÈ¹Ø¼ü×Ö¹¹³ÉµÄSqlÓï¾ä£¬º¯Êý·µ»ØÖµÎª²éѯËùÓ°ÏìµÄÐÐÊý£¬Ê§°Ü·µ»Ø-1¡££¨´í£©
15£®Ê¹ÓÃCachedRowSetImpl¶ÔÏó¿ÉÒÔ½ÚÊ¡Êý¾Ý¿âÁ¬½Ó×ÊÔ´£¬ÒòΪÕâ¸ö¶ÔÏó¿ÉÒÔ±£´æResultSet¶ÔÏóÖеÄÊý¾Ý£¬Ëü²»ÒÀÀµÓëConnection¶ÔÏ󣬲¢ÇҼ̳ÐÁËResultSetµÄËùÓз½·¨¡££¨¶Ô£©
Èý¡¢Ìî¿ÕÌâ
1£®JDBCµÄÓ¢ÎÄÈ«³ÆÊÇ_Java Data Base Connectivity__£¬ÖÐÎÄÒâÒåÊÇ___JavaÊý¾Ý¿âÁ¬½Ó__¡£ 2£®¼òµ¥µØËµ£¬JDBCÄܹ»Íê³ÉÏÂÁÐÈý¼þÊ£ºÓëÒ»¸öÊý¾Ý¿â½¨Á¢Á¬½Ó£¨connection£©¡¢ÏòÊý¾Ý¿â·¢ËÍSQLÓï¾ä£¨statement£© ¡¢ ´¦ÀíÊý¾Ý¿â·µ»ØµÄ½á¹û£¨resultset£© ¡£ 3£®JDBCÖ÷ÒªÓÉÁ½²¿·Ö×é³É£ºÒ»²¿·ÖÊÇ·ÃÎÊÊý¾Ý¿âµÄ¸ß²ã½Ó¿Ú£¬¼´Í¨³£Ëù˵µÄ JDBC API £»ÁíÒ»²¿·ÖÊÇÓÉÊý¾Ý¿â³§ÉÌÌṩµÄʹJava³ÌÐòÄܹ»ÓëÊý¾Ý¿âÁ¬½ÓͨÐŵÄÇý¶¯³ÌÐò£¬¼´ JDBC Database Driver ¡£ 4£®Ä¿Ç°£¬JDBCÇý¶¯³ÌÐò¿ÉÒÔ·ÖΪËÄÀࣺJDBC-ODBCÇÅ ¡¢²¿·ÖÓÃJavaÀ´±àдµÄ±¾µØAPIÇý¶¯³ÌÐò ¡¢JDBCÍøÂç´¿JavaÇý¶¯³ÌÐò ¡¢±¾µØÐÒé´¿JavaÇý¶¯³ÌÐò ¡£ 5£®Êý¾Ý¿âµÄÁ¬½ÓÊÇÓÉJDBC µÄ__ DrvierManagerÀà___¹ÜÀíµÄ¡£ 6£®ÏÂÃæµÄ´úÂ뽨Á¢MysqlÊý¾Ý¿âµÄÁ¬½Ó£¬ÇëÌî¿Õ£º try{ Class.forName(\ com.mysql.jdbc.Driver \ }
´´½¨Á¬½ÓµÄ´úÂëÈçÏÂ: try{ //ºÍÊý¾Ý¿â½¨Á¢Á¬½Ó conn=
DriverManager.getConnection( \ jdbc:mysql: //localhost:3306/booklib\ ¡¡
conn.close(); }
catch(Exception e){
out.println(e.toString()); }
7£®²éѯ½á¹û¼¯ResultSet¶ÔÏóÊÇÒÔͳһµÄÐÐÁÐÐÎʽ×éÖ¯Êý¾ÝµÄ£¬Ö´ÐÐResultSet rs = stmt.executeQuery (\Óï¾ä£¬µÃµ½µÄ½á¹û¼¯rsµÚÒ»ÁжÔÓà bid £»¶øÃ¿Ò»´ÎrsÖ»ÄÜ¿´µ½ Ò» ÐУ¬ÒªÔÚ¿´µ½ÏÂÒ»ÐУ¬±ØÐëʹÓà next() ·½·¨Òƶ¯µ±Ç°ÐС£ResultSet¶ÔÏóʹÓà getXXX() ·½·¨»ñµÃµ±Ç°ÐÐ×ֶεÄÖµ¡£
8£®stmtΪStatement¶ÔÏó£¬Ö´ÐÐString sqlStatement = \bid='tp1001' \Óï¾äºó£¬É¾³ýÊý¾Ý¿â±íµÄ¼Ç¼ÐèÒªÖ´ÐÐstmt.executeUpdate ( sqlStatement ); Óï¾ä¡£
9£®ÏÂÃæ´úÂëÊÇʹÓÃÊý¾Ý¿âÁ¬½Ó³Ø»ñµÃÁ¬½ÓµÄ´úÂëÆ¬¶Î£º Connection conn;
Context initCtx=new InitialContext();
Context ctx=(Context)initCtx.lookup(\ //»ñÈ¡Á¬½Ó³Ø¶ÔÏó
Object obj=(Object)ctx.lookup(\ //ÀàÐÍת»»
javax.sql.DataSource ds=(javax.sql.DataSource)obj; //µÃµ½Á¬½Ó conn=ds. getConnection() ; ËÄ¡¢Ë¼¿¼Ìâ
1£®Ê²Ã´ÊÇJDBC±à³Ì½Ó¿Ú£¿
2£®ÊÔÁоÙÒ»¸öÄãÔÚ±à³ÌºÍµ÷ÊÔÖÐÅöµ½µÄÊý¾Ý¿âÎÊÌâ¼°Æä½â¾ö°ì·¨¡£ 3£®ÈçºÎʵÏּǼ¼¯µÄÐвÙ×÷£¿ 4£®½øÐмǼ¶¨Î»µÄ·½·¨ÓÐÄÄЩ£¿
5£®Ê²Ã´ÊÇÊý¾Ý¿âÁ¬½Ó³Ø£¿ÈçºÎʹÓã¿
6£®Ê¹Óô¿JavaÇý¶¯²Ù×÷mysqlÊý¾Ý¿âµÄ²½Ö裿
7£®¼ÓÔØSql Server 2000´¿JavaÇý¶¯³ÌÐòµÄ´úÂëÊÇʲô£¿ 8£®Ê¹ÓÃÔ¤´¦ÀíÓï¾äºÍ´æ´¢¹ý³ÌÓÐʲôºÃ´¦£¿ 9£®Ê¹ÓÃCachedRowSetImplÀàÓÐʲôºÃ´¦£¿ 10£®ÈçºÎʹÓùö¶¯µÄ½á¹û¼¯£¿
µÚ°ËÕ Servlet¼¼Êõ
Ò»¡¢Ñ¡ÔñÌâ
1£®ÏÂÃæ¶ÔServlet¡¢AppletµÄÄÇÒ»ÏîÃèÊö´íÎ󣿣¨D£©
A£©ServeltÓëAppletÏà¶ÔÓ¦ B£©AppletÔËÐÐÔÚ¿Í»§¶Ëä¯ÀÀÆ÷ C£©ServletÔËÐÐÔÚWeb·þÎñÆ÷¶Ë
D£©ServletºÍApplet²»¿ÉÒÔ¶¯Ì¬´ÓÍøÂç¼ÓÔØ 2£®ÏÂÃæÄÄÒ»Ïî²»ÔÚServletµÄ¹¤×÷¹ý³ÌÖУ¿£¨B£©
A£©·þÎñÆ÷½«ÇëÇóÐÅÏ¢·¢ËÍÖÁServlet B£©¿Í»§¶ËÔËÐÐApplet
C£©ServletÉú³ÉÏìÓ¦ÄÚÈݲ¢½«Æä´«¸ø·þÎñÆ÷ D£©·þÎñÆ÷½«¶¯Ì¬ÄÚÈÝ·¢ËÍÖÁ¿Í»§¶Ë
3£®ÏÂÁÐÄÄÒ»Ïî²»ÊÇServletÖÐʹÓõķ½·¨£¿ £¨D£©
A£©doGet() B£©doPost() C£©service() D£©close()
4£®¹ØÓÚMVC¼Ü¹¹µÄȱµã£¬ÏÂÁеÄÐðÊöÄÄÒ»ÏîÊDz»ÕýÈ·µÄ£¿£¨B£© A£©Ìá¸ßÁ˶Կª·¢ÈËÔ±µÄÒªÇó B£©´úÂ븴ÓÃÂÊµÍ C£©Ôö¼ÓÁËÎļþ¹ÜÀíµÄÄÑ¶È D£©²úÉú½Ï¶àµÄÎļþ 5£®ÏÂÃæÄÄÒ»Ïî¶ÔServlet¡¢JSPµÄÃèÊö´íÎ󣿣¨D£©
A£©HTML¡¢JavaºÍ½Å±¾ÓïÑÔ»ìºÏÔÚÒ»ÆðµÄ³ÌÐò¿É¶ÁÐԽϲά»¤ÆðÀ´½ÏÀ§ÄÑ¡£ B£©JSP¼¼ÊõÊÇÔÚServletÖ®ºó²úÉúµÄ£¬ËüÒÔServletΪºËÐļ¼Êõ£¬ÊÇServlet¼¼ÊõµÄÒ»¸ö³É¹¦Ó¦Óá£
C£©µ±JSPÒ³Ãæ±»ÇëÇóʱ£¬JSPÒ³Ãæ»á±»JSPÒýÇæ·Òë³ÉServelt×Ö½ÚÂëÖ´ÐÐ D£©Ò»°ãÓÃJSPÀ´´¦ÀíÒµÎñÂß¼£¬ÓÃServletÀ´ÊµÏÖÒ³ÃæÏÔʾ¡£ 6£®ÏÂÃæÄÄÒ»Ïî¶ÔServlet¡¢JSPµÄÃèÊö´íÎ󣿣¨D£©
A£©Servlet¿ÉÒÔͬÆäËû×ÊÔ´½»»¥£¬ÀýÈçÎļþ¡¢Êý¾Ý¿â B£©Servlet¿ÉÒÔµ÷ÓÃÁíÒ»¸ö»òһϵÁÐServlet E£©·þÎñÆ÷½«¶¯Ì¬ÄÚÈÝ·¢ËÍÖÁ¿Í»§¶Ë E£©ServletÔÚ±íʾ²ãµÄʵÏÖÉÏ´æÔÚÓÅÊÆ 7£®ÏÂÃæÄÄÒ»Ïî¶ÔServletÃèÊö´íÎ󣿣¨C£©
A£©ServletÊÇÒ»¸öÌØÊâµÄJavaÀ࣬Ëü±ØÐëÖ±½Ó»ò¼ä½ÓʵÏÖServlet½Ó¿Ú B£©Servlet½Ó¿Ú¶¨ÒåÁËServeltµÄÉúÃüÖÜÆÚ·½·¨
C£©µ±¶à¸ö¿Í»§ÇëÇóÒ»¸öServletʱ£¬·þÎñÆ÷Ϊÿһ¸ö¿Í»§Æô¶¯Ò»¸ö½ø³Ì D£©Servlet¿Í»§Ï̵߳÷ÓÃservice·½·¨ÏìÓ¦¿Í»§µÄÇëÇó 8£®ÏÂÃæÄÄÒ»Ïî¶ÔServletÃèÊö´íÎ󣿣¨C£©
A£©ServletÊÇÒ»¸öÌØÊâµÄJavaÀ࣬Ëü±ØÐëÖ±½Ó»ò¼ä½ÓʵÏÖServlet½Ó¿Ú B£©Servlet½Ó¿Ú¶¨ÒåÁËServeltµÄÉúÃüÖÜÆÚ·½·¨
C£©µ±¶à¸ö¿Í»§ÇëÇóÒ»¸öServletʱ£¬·þÎñÆ÷Ϊÿһ¸ö¿Í»§Æô¶¯Ò»¸ö½ø³Ì D£©Servlet¿Í»§Ï̵߳÷ÓÃservice·½·¨ÏìÓ¦¿Í»§µÄÇëÇó
9£®ÏÂÃæServletµÄÄĸö·½·¨ÔØÈëʱִÐУ¬ÇÒÖ»Ö´ÐÐÒ»´Î£¬¸ºÔð¶ÔServlet½øÐгõʼ»¯¡££¨ B £©
A£©service() B£©init()
C£©doPost() D£©destroy()
10£®ÏÂÃæServletµÄÄĸö·½·¨ÓÃÀ´ÎªÇëÇó·þÎñ£¬ÔÚServletÉúÃüÖÜÆÚÖУ¬Servletÿ±»ÇëÇóÒ»´ÎËü¾Í»á±»µ÷ÓÃÒ»´Î¡££¨ A £© A£©service() B£©init() C£©doPost() D£©destroy()
11£®ÏÂÃæÄĸö·½·¨µ±·þÎñÆ÷¹Ø±Õʱ±»µ÷Óã¬ÓÃÀ´ÊÍ·ÅServletËùÕ¼µÄ×ÊÔ´¡££¨D£©
A£©service() B£©init() C£©doPost() D£©destroy()
12£®²¿ÊðServlet£¬ÏÂÃæÄÄÒ»ÏîÃèÊö´íÎ󣿣¨C£©
A£©±ØÐëΪTomcat±àдһ¸ö²¿ÊðÎļþ¡£ B£©²¿ÊðÎļþÃûΪweb.xml
C£©²¿ÊðÎļþÔÚWeb·þÎñĿ¼µÄWEB-INF×ÓĿ¼ÖÐ D£©²¿ÊðÎļþÃûΪServer.xml
13£®ÏÂÃæÊÇÒ»¸öServlet²¿ÊðÎļþµÄƬ¶Î£º
Hello
myservlet.example.FirstServlet
Hello /helpHello
ServletµÄÀàÃûÊÇ£¨ A £© A£©FirstServlet B£©Hello C£©helpHello D£©/helpHello
14£®ÏÂÃæÊÇServletµ÷ÓõÄÒ»ÖÖµäÐÍ´úÂ룺
<%@ page contentType=\<%@ page import=\