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���
Ïà¹ØÎĵµ£º
JavaÖ´ÐÐstm.executeQuery(sql); ʱ×ÜÊÇÌáʾ£ºjava.sql.SQLException: ORA-00911: ÎÞЧ×Ö·û£¬ÅªÁ˰ëÌ컹Êdzö´í£¬ÎÞÄΣ¬ÄóöɱÊÖïµ£¬Googleһϣ¬Ôε¹£¬·¢ÏÖÎÒµÄString sql = “select detail from test.result where person_id = 4; "£¬Ã²ËÆÃ»´íÎó°É£¬½á¹ûÎÒÎÒ±ØÐëÈ¥µô×îºó·ÖºÅ£¬±¾À´ÊÇÏë¸ãµÃרҵµã£¬¾Í¼Û¼Ó¸ö·Ö ......
Õâ²»ÊÇʲô½Ì²Ä£¬±ÊÕßÓÐʱ»áÔÚÂÛ̳ÉÏÇÆÇÆ£¬¿´µ½²»ÉÙ³õѧÕßÎʵ½ºÜ¶àÎÊÌ⣬ÕâЩÎÊÌâÊÇjava³ÌÐòÔ±Ó¦¸Ã¶®µÃµÄ£¬¶øÒ»°ãÊéÉϲ»»á½²µ½»òÕßÒ»±Ê´ø¹ýµÄ֪ʶ¡£Òò´Ë¶·µ¨Í¿Ñ»Ò»ÆªÎÄÕ£¬°ÑÏë˵µÄÔÚÕâÀïÒ»¿ÚÆøËµÍê¡£ÕâÒ²ÊDZ¾È˵ÚÒ»´Îд¼¼ÊõÐÔµÄÎÄÕ£¬Îıʲ»³©Ö®Í⣬»¹Çë¸÷λ¼ûÁ¡£
Ê×ÏȽ²Çå³þÀàºÍ¶ÔÏóµÄÇø±ð¡£
ÀàÊǹ㷺µÄ¸ÅÄ±íʾһ¸ö ......
Synchronized£¬¹ËÃû˼Ò壬´ú±í¶à¸öÏß³ÌÖ®¼äµÄͬ²½¡£ÄÇô£¬ÔÚjava±à³ÌÖÐÈçºÎʹÓÃËüÄØ£¿ ÎÒÃǼÙÉèÕâÑùÒ»¸öÇé¿ö£º¶ÔÓÚͬһ¸ö±äÁ¿synDemo£¬ÎÒÃÇ·Ö±ðÔÚ2¸ö²»Í¬µÄÏß³ÌÖе÷ÓÃsynDemo.synMethord1()ÓësynDemo.synMethord2()¡£ package com.cnblogs.gpcuster;
/**
*
* @author Aaron.Guo
*
*/
public class Tester { ......
Myeclipse±¨Could not create Java VM
»·¾³£º
Myeclipse6.0£¬tomcat6.0, 2GÄÚ´æ
½ñÌìһֱʹÓÃDEBUGģʽÆô¶¯tomcatÒ»Ö±ºÜÂý£¬ËùÒÔÏëʹÓÃRUNģʽÀ´Æô¶¯£¬µ«ÊÇÿ´ÎÆô¶¯¶¼±¨´í“could not create the java virtual machine”£¬ÌáʾÉèÖÃÄÚ´æ²»×㣬°Ù¶ÈÏ£¬¶¼ÒªÇóÐÞ¸Äeclipse.iniÅäÖÃÎļþ£¬µ«ÊÇÐÞ¸ÄÁ˲»ºÃÊ ......
public class DealLockTest implements Runnable {
static String i = new String();
static String j = new String();
private String str = null;
public DealLockTest(String str) {
this.str = str;
}
public static void main(String[] args) {
new Thread(new DealLockTest("i")).start( ......