sql和Oracle链接数据库及资源文件的解析.docxVIP

(1)sqlserver的数据库连接方式package com.chinalife.soaplatform.test;import java.sql.Connection;import java.sql.DriverManager;publicclass ConnectionUtil {privatestaticfinal String username = sa;privatestaticfinal String password = sa;privatestaticfinal String driverClass = com.microsoft.jdbc.sqlserver.SQLServerDriver;privatestaticfinal String url = jdbc.microsoft.sqlserver://localhost:1433;databaseName=sqlname;public Connection getConn() {Connection conn = null;try {Class.forName(driverClass).newInstance();conn = DriverManager.getConnection(url, username, password);if (conn != null) {System.out.println(数据库连接成功);}} catch (Exception e) {// TODO: handle exceptionSystem.out.println(数据库连接异常！);}return conn;}}Oracle的数据库连接方式package com.chinalife.soaplatform.test;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;publicclass ConnectionOracleUtil {privatestaticfinal String driverClass = oracle.jdbc.OracleDriver;privatestaticfinal String url = jdbc:oracle:thin:@localhost:1521:orcl;privatestaticfinal String username = dev_esb;privatestaticfinal String password = dev_esb;public Connection getConn() {Connection conn = null;try {Class.forName(driverClass).newInstance();conn = DriverManager.getConnection(url, username, password);if (conn != null) {System.out.println(数据库连接成功);}} catch (Exception e) {// TODO: handle exceptionSystem.out.println(数据库连接失败！);}return conn;}publicstaticvoid main(String[] args) {ConnectionOracleUtil util=new ConnectionOracleUtil();util.getConn();}}数据库测试类package com.chinalife.soaplatform.test;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;publicclass ConnectionTest {publicvoid test(){ConnectionOracleUtil util=new ConnectionOracleUtil();Connection conn=util.getConn();try {String sql=select * from city ;PreparedStatement pst=conn.prepareStatement(sql);ResultSet rs=pst.executeQuery();while(rs.next()){System.out.println(cityId:+rs.getString(id)+ cityname:+rs.getString