Tomcat配置数据源(JNDI方式).docx

Tomcat配置数据源（JNDI方式）一、直连接数据库1?Java 连接 Oralce[java]?view plaincopyClass.forName(oracle.jdbc.driver.OracleDriver).newInstance();??String?url=jdbc:oracle:thin:@localhost:1521:orcl;????Connection?conn=?DriverManager.getConnection(url,user,password);??2?Java 连接 MySQL[java]?view plaincopyClass.forName(org.gjt.mm.mysql.Driver?).newInstance();??String?URL?=?jdbc:mysql://localhost/test;??Connection?conn=?DriverManager.getConnection(url,user,password);??3 Java 连接SQLServer[java]?view plaincopyClass.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver?).newInstance();??String?URL?=”?jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs;??Connection?conn=?DriverManager.getConnection(url,user,password);??4 Java 连接DB2[java]?view plaincopyClass.forName(“com.ibm.db2.jdbc.app.DB2Driver?).newInstance();??String?URL?=”jdbc:db2://localhost:5000/sample;??Connection?conn=?DriverManager.getConnection(url,user,password);??5 Java 连接 Infomix[java]?view plaincopyClass.forName(rmix.jdbc.IfxDriver?).newInstance();??String?URL?＝jdbc:informix-sqli://9:1533/testDB:INFORMIXSERVER=myserver??Connection?conn=?DriverManager.getConnection(url,user,password);??6 Java 连接 SyBase[java]?view plaincopyClass.forName(com.sybase.jdbc.SybDriver).newInstance();??Properties?sysProps?=?System.getProperties();??SysProps.put(user,userid);??SysProps.put(password,user_password);??Connection?conn=?DriverManager.getConnection(url,?SysProps);??7 Java连接 PostgreSQL[java]?view plaincopyClass.forName(org.postgresql.Driver).newInstance();??String?url?=jdbc:postgresql://localhost/soft??Connection?conn=?DriverManager.getConnection(url,user,password);??二、 tomcat连接数据库（JNDI连接）1、先在自己应用程序WEB-INF目录下的web.xml添加以下语句：?[html]?view plaincopyresource-ref??????descrtiption引用资源说明/descrtiption??????res-ref-name引用资源的JNDI名/res-ref-name??????res-type引用资源的类名/res-type??????res-auth管理者（Container）/res-auth!--Container－容器管理?Application－Web应用管理--??/resource-ref??????? 然后在tomcat目录/conf/server.xml文件里相应的Context元素,添加如下子元素：[html]?view plaincopyResource?na