java 调用视图
来源:互联网 发布:敏感肌肤 面膜 知乎 编辑:程序博客网 时间:2024/06/05 04:12
1.创建视图:
create or replace view es_company_code as
(select ESCO_COMPANY_NO as COMPANY_CODE,ESCO_COMPANY_NAME_CN as COMPANY_NAME,ESCO_COMPANY_TYPE AS COMPANY_TYPE from ES_COMPANY
where ESCO_COMPANY_TYPE like '%C%');
2.使用java调用
- 数据库访问类
/**
*
*/
package db;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* 〈一句话功能简述〉 〈功能详细描述〉 版本:1.0 作者:Bill 修改日期:2017-11-27 修改内容:
*/
public class DbConnectionUtil {
private final static String driver = "oracle.jdbc.driver.OracleDriver";
private final static String url = "jdbc:oracle:thin:@172.23.2.19:1521/pdborcl.localdomain";
private final static String account = "xxxxx";
private final static String password = "xxxxx";
public static Connection openConnectionDB() {
Connection conn = null;
try {
Class.forName(driver);
conn = DriverManager.getConnection(url, account, password);
} catch (SQLException ex2) {
ex2.printStackTrace();
} catch (Exception ex2) {
ex2.printStackTrace();
} finally {
return conn;
}
}
// 关闭连接
public static void closeConnectionDB(Connection conn, CallableStatement stat, ResultSet rs) {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
rs = null;
}
}
if (stat != null) {
try {
stat.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
stat = null;
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
conn = null;
}
}
}
}
*
*/
package db;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* 〈一句话功能简述〉 〈功能详细描述〉 版本:1.0 作者:Bill 修改日期:2017-11-27 修改内容:
*/
public class DbConnectionUtil {
private final static String driver = "oracle.jdbc.driver.OracleDriver";
private final static String url = "jdbc:oracle:thin:@172.23.2.19:1521/pdborcl.localdomain";
private final static String account = "xxxxx";
private final static String password = "xxxxx";
public static Connection openConnectionDB() {
Connection conn = null;
try {
Class.forName(driver);
conn = DriverManager.getConnection(url, account, password);
} catch (SQLException ex2) {
ex2.printStackTrace();
} catch (Exception ex2) {
ex2.printStackTrace();
} finally {
return conn;
}
}
// 关闭连接
public static void closeConnectionDB(Connection conn, CallableStatement stat, ResultSet rs) {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
rs = null;
}
}
if (stat != null) {
try {
stat.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
stat = null;
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
conn = null;
}
}
}
}
2.调用
/**
*
*/
package db;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import db.model.Company;
/**
* 〈一句话功能简述〉 〈功能详细描述〉 版本:1.0 作者:Bill 修改日期:2017-11-27 修改内容:
*/
public class DbViewDemo {
/**
* 〈一句话功能简述〉
*
* @param
* @param
* @return
* @author Bill
* @throws
*/
public static void main(String[] args) {
Connection conn = null;
CallableStatement cstmt = null;
ResultSet rs = null;
try {
conn = DbConnectionUtil.openConnectionDB();
cstmt = conn.prepareCall("SELECT * FROM es_company_code WHERE COMPANY_TYPE=?");
cstmt.setString(1, "C");
rs = cstmt.executeQuery();// 执行
List<Company> companyList = new ArrayList<Company>();
while (rs.next()) {
Company company = new Company(rs.getString("COMPANY_CODE"), rs.getString("COMPANY_NAME"), rs.getString("COMPANY_TYPE"));
System.out.println(company);
companyList.add(company);
}
} catch (SQLException ex2) {
ex2.printStackTrace();
} catch (Exception exception) {
exception.printStackTrace();
} finally {
DbConnectionUtil.closeConnectionDB(conn, cstmt, rs);
}
}
}
*
*/
package db;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import db.model.Company;
/**
* 〈一句话功能简述〉 〈功能详细描述〉 版本:1.0 作者:Bill 修改日期:2017-11-27 修改内容:
*/
public class DbViewDemo {
/**
* 〈一句话功能简述〉
*
* @param
* @param
* @return
* @author Bill
* @throws
*/
public static void main(String[] args) {
Connection conn = null;
CallableStatement cstmt = null;
ResultSet rs = null;
try {
conn = DbConnectionUtil.openConnectionDB();
cstmt = conn.prepareCall("SELECT * FROM es_company_code WHERE COMPANY_TYPE=?");
cstmt.setString(1, "C");
rs = cstmt.executeQuery();// 执行
List<Company> companyList = new ArrayList<Company>();
while (rs.next()) {
Company company = new Company(rs.getString("COMPANY_CODE"), rs.getString("COMPANY_NAME"), rs.getString("COMPANY_TYPE"));
System.out.println(company);
companyList.add(company);
}
} catch (SQLException ex2) {
ex2.printStackTrace();
} catch (Exception exception) {
exception.printStackTrace();
} finally {
DbConnectionUtil.closeConnectionDB(conn, cstmt, rs);
}
}
}
阅读全文
0 0
- java 调用视图
- 求关于JAVA后台调用视图,后台调用存储过程,视图调用存储过程的书,越详细越好
- Java 视图
- view视图的调用方法
- 视图调用存储过程全局变量
- 在C#中调用视图
- 视图调用控制器的方法
- MVC调用部分视图PartialView
- MVC5局部视图的调用
- 六.控制器调用VIEW视图
- java 访问数据库视图
- java基础学习视图
- java关系视图
- 用调用的视图和存储过程
- 调用名片夹视图选择名片信息
- SMS调用系统的浏览视图
- thinkphp 定义视图模型调用关联查询
- MVC中部分视图调用方法
- 冒泡排序
- 【学习笔记】dubbo 控制台的部署
- C语言经典面试题(一)——(持续更新)
- 数据结构(二分查找)
- Wifi 源码学习之wifi列表
- java 调用视图
- redis、memcache和mongodb各自的优缺点是什么,怎么选择呢?
- windows向linux复制文件
- 编译网易云信项目错误问题记录
- 3.0studio 创建新的工程后报错
- ROS server and client
- AutoMapper官方文档(九)【列表和数组】
- 联网处理之如何把json作为参数传递,要用【RequestBody】
- Ubuntu下安装BigChainDB