路虽远行则将至，事虽难做则必成

本文主要是总结 如何实现 JDBC调用Oracle的存储过程，从以下情况分别介绍：[1]、只有输入IN参数，没有输出OUT参数[2]、既有输入IN参数，也有输出OUT参数，输出是简单值（非列表）[3]、既有输入IN参数，也有输出OUT参数，输出是列表[4]、输入输出参数是同一个（IN OUT）[5]、存储过程中 使用 truncate 截断表中的数据【准备工作】  创建一个测试表TM

Size=5maxActive=20minIdle=2maxStatements=180[/size][code="java"]package com.enhance.jdbc;import java.io.FileInputStream;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.s

* * SQL语句的分类 * select 语句 * DML:(Data Manipulation Language)数据操作语言：检索 select 和 更新insert update delete * DDL:(Data Definition Language)数据定义语言： create alter drop truncate * DCL:(Data Control Language)数据控制语言：grant revoke * 事物控制语句:commit rollback sa

import java.sql.SQLException;import java.sql.Statement;import java.util.Properties;public class PreparedStatementTest { private String driver; private String url; private String user; private String pass; private Statement stmt; priva

import java.sql.ResultSetMetaData;import java.sql.Statement;import java.util.Properties;public class ResutSetTest { private String driver; private String url; private String user; private String pass; private Connection conn; privat

blic class BatchTest { private String driver; private String url; private String user; private String pass; private Connection conn; private Statement stmt; public void initParam(String paramFile) throws Exception{ Properties prop=new Prop

;import java.awt.BorderLayout;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.io.FileInputStream;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.ResultS

ort java.sql.Statement;import java.util.Properties;public class TransactionTest { private String driver; private String url; private String user; private String pass; private Connection conn; private Statement stmt; public void ini

port java.awt.BorderLayout;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.awt.event.MouseAdapter;import java.awt.event.MouseEvent;import java.io.File;import java.io.FileInputStream;import java.io.InputStrea

[code="java"]package com.enhance.jdbc;import java.beans.PropertyVetoException;import java.io.File;import java.io.FileInputStream;import java.io.FileOutputStream;import java.io.IOExceptio...

做个简单 图片上传和浏览的工具[img]http://dl2.iteye.com/upload/attachment/0089/8799/950f5b36-81db-3e09-aa57-8d389ff6a212.jpg[/img][code="java"]package com.enhance.jdbc.blob;import java.awt.BorderLayout;...

加入  mysql的驱动jar:  mysql-connector-java-5.1.25-bin.jarmysql.ini 的内容driver=com.mysql.jdbc.Driverurl=jdbc:mysql://127.0.0.1:3306/mysqluser=rootpass=123456initialSize=5maxActive=20minIdle=2maxSt

[size=small]加入 mysql的驱动jar: mysql-connector-java-5.1.25-bin.jarmysql.ini 的内容driver=com.mysql.jdbc.Driverurl=jdbc:mysql://127.0.0.1:3306/mysqluser=rootpass=123456initialSize=5maxActiv...

[code="java"]package com.enhance.jdbc;import java.io.FileInputStream;import java.sql.Connection;import java.sql.DriverManager;import java.sql.Statement;import java.util.Properties;/*...

[code="java"]package com.enhance.jdbc;import java.io.FileInputStream;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;...

[code="java"]package com.enhance.jdbc;import java.io.FileInputStream;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;...

[code="java"]package com.enhance.jdbc;import java.io.FileInputStream;import java.sql.Connection;import java.sql.DriverManager;import java.sql.Statement;import java.util.Properties;pu...

[size=medium]ResultSetMetaData:用来分析 "结果集"信息DatabaseMetaData:用来分析是"数据库"信息[/size]//做一个简单的 查询执行器[code="java"]package com.enhance.jdbc;import java.awt.BorderLayout;import java.awt.event.Ac...

[code="java"]package com.enhance.jdbc;import java.io.FileInputStream;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.sql.Savepoint;imp...

n;import java.io.OutputStream;import java.sql.Blob;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.util.Properties;import com.mchange.v2.c3p0.ComboPooledDataS