第1个回答 2016-05-12
在struts-config.xml文件下 加入
-<data-sources> -<data-source type="oracle.jdbc.pool.OracleDataSource"> <set-property value="false" property="autoCommit"/> <set-property value="ORACLE Data Source" property="description"/> <set-property value="oracle.jdbc.driver.OracleDriver" property="driverClass"/> <set-property value="20" property="maxCount"/> <set-property value="2" property="minCount"/> <set-property value="dhee" property="user"/> <set-property value="dhee" property="password"/> <set-property value="jdbc:oracle:thin:@localhost:1521:orcl" property="URL"/> </data-source> </data-sources>
第2个回答 推荐于2018-04-13
public static ResultSet oracleConn(String sql) {
String driver = "oracle.jdbc.driver.OracleDriver";
//写明你数据的连接串
String url = "jdbc:Oracle:thin:@192.168.1.1:3004/xe";
Statement stmt = null;
ResultSet res = null;
Connection conn = null;
CallableStatement proc = null;
List<SqlResult> list = new ArrayList();
try {
Class.forName(driver);
//连接数据库
conn = DriverManager.getConnection(url, "username",
"password");
stmt = conn.createStatement();
//执行sql语句,并返回结果
res = stmt.executeQuery(sql);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return res ;
}本回答被网友采纳
第4个回答 2016-06-21
请说详细点。完全看不懂,
是java连接数据库的配置文件?
创建数据库?
第5个回答 2016-07-03
该怎么建怎么建,没有专门适配java的oracle这一说,只有java对应的oracle驱动