使用JDBC获取Oracle数据

来源：互联网发布：三星专用软件下载编辑：程序博客网时间：2024/06/01 21:26

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.PreparedStatement;
import java.util.Date;

public class Jdbctest {

   /**
   * JDBC连接Oracle数据库
   * @param args
   */
   public static void main(String[] args) {
       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;
       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()) {
               String orderno = rs.getString("ORDER_NO");
               String transtype = rs.getString("TRANS_TYPE");
               String hostssn = rs.getString("HOST_SSN");
               String instdate = rs.getString("INST_DATE");
               String termssn = rs.getString("TERM_SSN");
               System.out.println(orderno + "\t" + transtype + "\t" + hostssn + "\t"
                       + termssn);
           }
           flag=true;
       } catch (ClassNotFoundException e) {
           e.printStackTrace();
       } catch (SQLException e) {
           e.printStackTrace();
       }finally{
           if(rs!=null){

               try {
                   rs.close();
               } catch (SQLException e) {
                   e.printStackTrace();
               }
       }
       //关闭执行通道
       if(pstm!=null){

           try {
               pstm.close();
           } catch (SQLException e) {
               e.printStackTrace();
           }
       }
       //关闭连接通道
       try {
           if(con!=null&&(!con.isClosed())){
               try {
                   con.close();
               } catch (SQLException e) {
                       e.printStackTrace();
                   }
           }
       } catch (SQLException e) {
           e.printStackTrace();
       }
       }
       if(flag){
           System.out.println("成功！");
       }else{
           System.out.println("失败！");
       }
   }
}

0 0