javaÁ¬½ÓOracle
»¨ÁËÁ½Ììʱ¼ä£¬ÖÕÓÚ°ÑaccessÊý¾Ý¿âÀïµÄÊý¾Ý»»µ½OracleÁË¡£µ±È»ÕâÆäÖÐÒª¸ÐлͬѧºÍ²©ÓѵÄÈÈÐİïÖúÀ¡£ÏÖ½«½ñÌìµÄÊÕ»ñÕûÀíÏ¡£
ÎÒÓõÄÊÇOracle 10 express edition°æ±¾£¬Õâ¸ö°æ±¾½¨Êý¾Ý¿âͦÂé·³µÄ£¬ËùÒÔÎÒ¾ÍÖ±½ÓÔÚËü×Ô´øµÄÊý¾Ý¿âXEϽ¨±íÁË¡£
×¢Ò⣺½¨±í¿ÉÒ»¶¨Òª×¢Òâ´óСдµÄŶ£¬Ä¬ÈÏʹÓõÄÊÇ´óд£¬±íÃûÓÐСдµÄ»°£¬ÐèÒª¼ÓË«ÒýºÅ£¬²Å¿ÉÒÔ²éѯµ½£¬·ñÔò¾Í³ö´íÁË¡£
½¨ºÃÊý¾Ý±íºó£¬¾ÍÊÇÁ¬½ÓÁË£¬Ð´ÁËÈý¸öÎļþ£¬DBConfig.property£¨ÅäÖÃÎļþ£¬¿ÉÒÔÑ¡ÔñÁ¬½Ó²»Í¬µÄÊý¾Ý¿âÀàÐÍ£©£¬DBConnection.java£¨Êý¾Ý¿âÁ¬½ÓÀࣩ£¬GetData.java£¨»ñÈ¡Êý¾ÝÀࣩ
×¢Ò⣺ÔÚÁ¬½Ó֮ǰ£¬Òª°ÑjdbcÇý¶¯(Ò»°ãÔÚ°²×°Â·¾¶\oraclexe\app\oracle\product\10.2.0\server\jdbc\libÏ£¬²»ÖªµÀÄĸöÓÐÓã¬ÎÒ¾ÍÁ½¸ö¶¼·ÅÉÏÈ¥ÁË£¬ºÇºÇ)·Åµ½tomcat\lib£¨D:\Program Files\Apache Software Foundation\Tomcat 6.0\lib£©ÏÂ
DBConfig.property´úÂëÈçÏ£º
//0:Access,1:MYSQL,2:MSSQL,3:Oracle
DBType=3
#Access
#Access
AccessDriver=sun.jdbc.odbc.JdbcOdbcDriver
#Access
AccessURL=jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=
#Access
AccessPath=D:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/db/DreamNews.mdb
#MySQL
MySQLDriver=org.gjt.mm.mysql.Driver
#MySQL
#DreamTimeNews
MySQLURL=jdbc:mysql://localhost:3306/DreamTimeNews?user=dreamnews&password=dreamnews&useUnicode=true&characterEncoding=GBK
#SQL Server
#SQL Server
SQLDriver=net.sourceforge.jtds.jdbc.Driver
#SQL Server
#DreamTimeNews
SQLURL=jdbc:jtds:sqlserver://localhost:1433/DreamTimeNews;user=dreamnews;password=dreamnews
#Oracle
OracleDriver=oracle.jdbc.driver.OracleDriver
OracleURL=jdbc:oracle:thin:@localhost:1521:XE
OracleUsername=hr
OraclePassword=hr
DBConnection.java´úÂëÈçÏ£º
/***************************************************
*
* Դ�ļ���: DBConnecion.java
* �� �ܣ� ��ݿ�l���
Ïà¹ØÎĵµ£º
ÀàµÄ³õʼ»¯ºÍ¶ÔÏó³õʼ»¯ÊÇ JVM ¹ÜÀíµÄÀàÐÍÉúÃüÖÜÆÚÖзdz£ÖØÒªµÄÁ½¸ö»·½Ú£¬Google ÁËÒ»±éÍøÂ磬ÓйØÀà×°ÔØ»úÖÆµÄÎÄÕµ¹ÊDz»ÉÙ£¬È»¶øÀà³õʼ»¯ºÍ¶ÔÏó³õʼ»¯µÄÎÄÕ²¢²»¶à£¬ÌرðÊÇ´Ó×Ö½ÚÂëºÍ JVM ²ã´ÎÀ´·ÖÎöµÄÎÄÕ¸üÊÇÏÊÓÐËù¼û¡£
±¾ÎÄÖ÷Òª¶ÔÀàºÍ¶ÔÏó³õʼ»¯È«¹ý³Ì½øÐзÖÎö£¬Í¨¹ýÒ»¸öʵ¼ÊÎÊÌâÒýÈ룬½«Ô´´úÂëת»»³É JVM ×Ö½ÚÂëºó£¬ ......
JavaÖ´ÐÐstm.executeQuery(sql); ʱ×ÜÊÇÌáʾ£ºjava.sql.SQLException: ORA-00911: ÎÞЧ×Ö·û£¬ÅªÁ˰ëÌ컹Êdzö´í£¬ÎÞÄΣ¬ÄóöɱÊÖïµ£¬Googleһϣ¬Ôε¹£¬·¢ÏÖÎÒµÄString sql = “select detail from test.result where person_id = 4; "£¬Ã²ËÆÃ»´íÎó°É£¬½á¹ûÎÒÎÒ±ØÐëÈ¥µô×îºó·ÖºÅ£¬±¾À´ÊÇÏë¸ãµÃרҵµã£¬¾Í¼Û¼Ó¸ö·Ö ......
Myeclipse±¨Could not create Java VM
»·¾³£º
Myeclipse6.0£¬tomcat6.0, 2GÄÚ´æ
½ñÌìһֱʹÓÃDEBUGģʽÆô¶¯tomcatÒ»Ö±ºÜÂý£¬ËùÒÔÏëʹÓÃRUNģʽÀ´Æô¶¯£¬µ«ÊÇÿ´ÎÆô¶¯¶¼±¨´í“could not create the java virtual machine”£¬ÌáʾÉèÖÃÄÚ´æ²»×㣬°Ù¶ÈÏ£¬¶¼ÒªÇóÐÞ¸Äeclipse.iniÅäÖÃÎļþ£¬µ«ÊÇÐÞ¸ÄÁ˲»ºÃÊ ......
LuceneÊÇÒ»¸ö»ùÓÚJavaµÄÈ«ÎÄË÷Òý¹¤¾ß°ü¡£
»ùÓÚJavaµÄÈ«ÎÄË÷ÒýÒýÇæLucene¼ò½é£º¹ØÓÚ×÷ÕߺÍLuceneµÄÀúÊ·
È«ÎļìË÷µÄʵÏÖ£ºLueneÈ«ÎÄË÷ÒýºÍÊý¾Ý¿âË÷ÒýµÄ±È½Ï
ÖÐÎÄÇзִʻúÖÆ¼ò½é£º»ùÓÚ´Ê¿âºÍ×Ô¶¯ÇзִÊËã·¨µÄ±È½Ï
¾ßÌåµÄ°²×°ºÍʹÓüò½é£ºÏµÍ³½á¹¹½éÉܺÍÑÝʾ
Hacking Lucene£º¼ò»¯µÄ²éѯ·ÖÎöÆ÷£¬É¾³ýµÄʵÏÖ£¬¶¨ÖƵÄÅÅÐò£ ......
×î½üÓÃinstallanywhere×öÁËÒ»¸ö°²×°°ü£¬Ð¶ÔصÄʱºò×ÜÊdzöÏÖ“ÔØÈëjava vmʱwindows³öÏÖ´íÎó£º3”£¬ºÜ²»Ë¬£¬ÉÏÍø²é¿´ÔÒò£¬ÔÀ´ÊÇÒòΪÖмäÎÒÖØÐ¸ü»»¹ýjdkµÄ°æ±¾£¬ÏÖÔÚÓÐЩÈí¼þ×Ô´øVM»òJDK£¬windowsϵͳͨ¹ý×¢²á±íÀ´¹ÜÀíµ±Ç°ÏµÍ³ËùʹÓõÄVMºÍJDK·¾¶£¬Òò´Ë£¬µ±°²×°µÄÈí¼þJDK°æ±¾ºÍ ......