java操作oracle数据库示例程序，用的是jdbc方式

来源：互联网发布：淘宝正品化妆品店编辑：程序博客网时间：2024/06/07 15:35

package prj_find;

import java.sql.*;

public class TSql {

   void t_find()
   {
       java.sql.Connection conn = null;
       java.sql.Statement sm = null;
       java.sql.ResultSet rs = null;

       try
       {
           Class.forName("oracle.jdbc.driver.OracleDriver");


           conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:hjs","mydb","hjs12345");

           sm = conn.createStatement();

           rs = sm.executeQuery("select * from tcustomers");

           while(rs.next())
           {
               System.out.println("name:" + rs.getString("tname") + " id: " +
                       rs.getString("tid") + " desc: " + rs.getString("tdesc"));
           }


       }
       catch(Exception e)
       {
           e.printStackTrace();

       }
       finally
       {
           try
           {
               rs.close();
               sm.close();
               conn.close();
           }
           catch(Exception e1)
           {
               e1.printStackTrace();
           }
       }

   }

   void t_insert()
   {
       java.sql.Connection conn = null;
       java.sql.Statement sm = null;

       try
       {
           Class.forName("oracle.jdbc.driver.OracleDriver");


           conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:hjs","mydb","hjs12345");

           sm = conn.createStatement();

           String sql = "insert into tcustomers(tid, tname, tdesc) values('"
           + "430408198301220020" + "','" + "李四" + "','" + "test" + "')";

           System.out.println(sql);

           sm.executeQuery(sql);

           sql = "update tcustomers set tname = '王五' where tname = '李四'";

           System.out.println(sql);

           sm.executeQuery(sql);

       }
       catch(Exception e)
       {
           e.printStackTrace();

       }
       finally
       {
           try
           {
               sm.close();
               conn.close();
           }
           catch(Exception e1)
           {
               e1.printStackTrace();
           }
       }
   }

   void t_delete()
   {
       java.sql.Connection conn = null;
       java.sql.Statement sm = null;

       try
       {
           Class.forName("oracle.jdbc.driver.OracleDriver");


           conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:hjs","mydb","hjs12345");

           sm = conn.createStatement();

           String sql = "delete from tcustomers where tname = '王五'";

           System.out.println(sql);

           sm.executeQuery(sql);
       }
       catch(Exception e)
       {
           e.printStackTrace();

       }
       finally
       {
           try
           {
               sm.close();
               conn.close();
           }
           catch(Exception e1)
           {
               e1.printStackTrace();
           }
       }
   }

   public static void main(String[] args) {
       // TODO Auto-generated method stub
       TSql t = new TSql();
       t.t_insert();
       t.t_find();
       t.t_delete();
       t.t_find();
   }

}

0 0