package cn.du.quartz;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.PrintStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class Jdbctest {
/**
* JDBC连接Oracle数据库
* @param args
* @throws IOException
* @throws SQLException
*/
public static void main(String[] args) throws IOException, SQLException {
String driver = "oracle.jdbc.driver.OracleDriver";// 驱动字符串
String url = "jdbc:oracle:thin:@10.10.1.15:1550:paytest";// 链接字符串
String user = "posp";// 用户名
String password = "posp";// 密码
Connection con = null;
PreparedStatement pstm = null;
ResultSet rs = null;
boolean flag=false;
File file = new File("sql.txt");//创建一个文件
FileOutputStream out = new FileOutputStream(file);
PrintStream ps = new PrintStream(out);
try {
Class.forName(driver);
con = DriverManager.getConnection(url, user, password);
String sql = "select * from TBL_N_TXN";
pstm = con.prepareStatement(sql);
rs = pstm.executeQuery();
while (rs.next()) {
ps.print(rs.getString("ORDER_NO")+"\t");
ps.print(rs.getString("TRANS_CODE")+"\t");
ps.print(rs.getString("TRANS_STATE")+"\t");
ps.print(rs.getString("HOST_SSN")+"\t");
ps.println(rs.getString("INST_DATE"));
}
flag=true;
} catch (ClassNotFoundException e) {
e.printStackTrace();
}finally{
ps.close();
rs.close();
pstm.close();
con.close();
}
if(flag){
System.out.println("执行成功!");
}else{
System.out.println("执行失败!");
}
}
}
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.PrintStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class Jdbctest {
/**
* JDBC连接Oracle数据库
* @param args
* @throws IOException
* @throws SQLException
*/
public static void main(String[] args) throws IOException, SQLException {
String driver = "oracle.jdbc.driver.OracleDriver";// 驱动字符串
String url = "jdbc:oracle:thin:@10.10.1.15:1550:paytest";// 链接字符串
String user = "posp";// 用户名
String password = "posp";// 密码
Connection con = null;
PreparedStatement pstm = null;
ResultSet rs = null;
boolean flag=false;
File file = new File("sql.txt");//创建一个文件
FileOutputStream out = new FileOutputStream(file);
PrintStream ps = new PrintStream(out);
try {
Class.forName(driver);
con = DriverManager.getConnection(url, user, password);
String sql = "select * from TBL_N_TXN";
pstm = con.prepareStatement(sql);
rs = pstm.executeQuery();
while (rs.next()) {
ps.print(rs.getString("ORDER_NO")+"\t");
ps.print(rs.getString("TRANS_CODE")+"\t");
ps.print(rs.getString("TRANS_STATE")+"\t");
ps.print(rs.getString("HOST_SSN")+"\t");
ps.println(rs.getString("INST_DATE"));
}
flag=true;
} catch (ClassNotFoundException e) {
e.printStackTrace();
}finally{
ps.close();
rs.close();
pstm.close();
con.close();
}
if(flag){
System.out.println("执行成功!");
}else{
System.out.println("执行失败!");
}
}
}