import javax.sql.DataSource;
 
import org.springframework.jdbc.support.incrementer.OracleSequenceMaxValueIncrementer;
 
import com.sinotrans.framework.core.util.ContextUtils;
 
public class OracleSequence {
 
private static DataSource ds = null;
 
//静态初始化一个数据源
 
static {
 
if (ds == null)
 
ds = (DataSource) ContextUtils.getBean("dataSource");
 
}
 
//定义静态方法
 
public static String getNextVal(String seqName) {
 
OracleSequenceMaxValueIncrementer incr = new OracleSequenceMaxValueIncrementer(ds, seqName);
 
return incr.nextStringValue();
 
}
 
//定义静态方法
 
public static Long getNextValLong(String seqName) {
 
OracleSequenceMaxValueIncrementer incr = new OracleSequenceMaxValueIncrementer(ds, seqName);
 
return incr.nextLongValue();
 
}
 
}

 
ResultSetMetaData metaDate = rs。getMetaData();
 
int number = metaDate。getColumnCount();
 
String[] column = new String[number];
 
for (int j = 0; j < column。
 
length; j++)
 
{
 
column[j] = metaDate。getColumnName(j + 1);
 
}
 
//将字段名保存到数组column中
 
String getCatalogName(int column)
 
Gets the designated column’s table’s catalog name。
 
String getColumnClassName(int column)
 
Returns the fully-qualified name of the Java class whose instances are manufactured if the method ResultSet。
 
getObject is called to retrieve a value from the column。
 
int getColumnCount()
 
Returns the number of columns in this ResultSet object。
 
int getColumnDisplaySize(int column)
 
Indicates the designated column’s normal maximum width in characters。
 
String getColumnLabel(int column)
 
Gets the designated column’s suggested title for use in printouts and displays。
 
String getColumnName(int column)
 
Get the designated column’s name。
 
int getColumnType(int column)
 
Retrieves the designated column’s SQL type。
 
String getColumnTypeName(int column)
 
Retrieves the designated column’s database-specific type name。
 
int getPrecision(int column)
 
Get the designated column’s number of decimal digits。
 
int getScale(int column)
 
Gets the designated column’s number of digits to right of the decimal point。
 
String getSchemaName(int column)
 
Get the designated column’s table’s schema。
 
String getTableName(int column)
 
Gets the designated column’s table name。
 
全部

 
ADF中获得数据库连接，读取xml文件的数据，并将其写到数据库中：
 
public static void main(String[] argv) throws Exception {
 
//获得驱动
 
Class driverClass = Class.forName("oracle.jdbc.OracleDriver");
 
//连接数据库的用户
 
Connection jdbcConnection =
 
DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE",
 
"CampusAccounts", "xxxxxx");
 
//新建一个数据库连接
 
IDatabaseConnection connection = new DatabaseConnection(jdbcConnection);
 
//读取本地的xml文件
 
IDataSet dataSet = new FlatXmlDataSet(new File("c://CampusAccounts.xml"));
 
try {
 
//将数据写到数据库用户的表中            DatabaseOperation.CLEAN_INSERT.execute(connection, dataSet);        }  finally {            connection.close();        }     }

 
package request;
 
/**
 
* Java获取数据库的表中各字段的字段名
 
* @author Perry
 
*
 
*/
 
import java.sql.Connection;
 
import java.sql.DriverManager;
 
import java.sql.ResultSet;
 
import java.sql.PreparedStatement;
 
import java.sql.ResultSetMetaData;
 
import java.sql.SQLException;
 
public class getTableName {
 
public static Connection getConnection() {
 
Connection conn = null;
 
try {
 
Class.forName("com.mysql.jdbc.Driver");
 
String url = "jdbc:mysql://192.168.150.93:3306/aaaa";
 
String user = "mysql";
 
String pass = "mysql";
 
conn = DriverManager.getConnection(url, user, pass);
 
} catch (ClassNotFoundException e) {
 
e.printStackTrace();
 
} catch (SQLException e) {
 
e.printStackTrace();
 
}
 
return conn;
 
}
 
public static void main(String[] args) {
 
Connection conn = getConnection();
 
String sql = "select * from sys_user";
 
PreparedStatement stmt;
 
try {
 
stmt = conn.prepareStatement(sql);
 
ResultSet rs = stmt.executeQuery(sql);
 
ResultSetMetaData data = rs.getMetaData();
 
for (int i = 1; i <= data.getColumnCount(); i++) {
 
// 获得所有列的数目及实际列数
 
int columnCount = data.getColumnCount();
 
// 获得指定列的列名
 
String columnName = data.getColumnName(i);
 
// 获得指定列的列值
 
int columnType = data.getColumnType(i);
 
// 获得指定列的数据类型名
 
String columnTypeName = data.getColumnTypeName(i);
 
// 所在的Catalog名字
 
String catalogName = data.getCatalogName(i);
 
// 对应数据类型的类
 
String columnClassName = data.getColumnClassName(i);
 
// 在数据库中类型的最大字符个数
 
int columnDisplaySize = data.getColumnDisplaySize(i);
 
// 默认的列的标题
 
String columnLabel = data.getColumnLabel(i);
 
// 获得列的模式
 
String schemaName = data.getSchemaName(i);
 
// 某列类型的精确度(类型的长度)
 
int precision = data.getPrecision(i);
 
// 小数点后的位数
 
int scale = data.getScale(i);
 
// 获取某列对应的表名
 
String tableName = data.getTableName(i);
 
// 是否自动递增
 
boolean isAutoInctement = data.isAutoIncrement(i);
 
// 在数据库中是否为货币型
 
boolean isCurrency = data.isCurrency(i);
 
// 是否为空
 
int isNullable = data.isNullable(i);
 
// 是否为只读
 
boolean isReadOnly = data.isReadOnly(i);
 
// 能否出现在where中
 
boolean isSearchable = data.isSearchable(i);
 
System.out.println(columnCount);
 
System.out.println("获得列" + i + "的字段名称:" + columnName);
 
System.out.println("获得列" + i + "的类型,返回SqlType中的编号:"+ columnType);
 
System.out.println("获得列" + i + "的数据类型名:" + columnTypeName);
 
System.out.println("获得列" + i + "所在的Catalog名字:"+ catalogName);
 
System.out.println("获得列" + i + "对应数据类型的类:"+ columnClassName);
 
System.out.println("获得列" + i + "在数据库中类型的最大字符个数:"+ columnDisplaySize);
 
System.out.println("获得列" + i + "的默认的列的标题:" + columnLabel);
 
System.out.println("获得列" + i + "的模式:" + schemaName);
 
System.out.println("获得列" + i + "类型的精确度(类型的长度):" + precision);
 
System.out.println("获得列" + i + "小数点后的位数:" + scale);
 
System.out.println("获得列" + i + "对应的表名:" + tableName);
 
System.out.println("获得列" + i + "是否自动递增:" + isAutoInctement);
 
System.out.println("获得列" + i + "在数据库中是否为货币型:" + isCurrency);
 
System.out.println("获得列" + i + "是否为空:" + isNullable);
 
System.out.println("获得列" + i + "是否为只读:" + isReadOnly);
 
System.out.println("获得列" + i + "能否出现在where中:"+ isSearchable);
 
}
 
} catch (SQLException e) {
 
e.printStackTrace();
 
}
 
}
 
}