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();
}
}