java连接oracle实例

 

---

加入架包:Oracle14.jar

 

---

jdbc程序:

 

---

package common;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class JDBC
 {

  Connection con = null;
  Statement stmt = null;
  ResultSet rs = null;
  String url = "jdbc:oracle:thin:@192.168.1.100:1521:orcl";//192.168.1.100为主机IP,1521端口,一般默认为次端口,orcl为数据库
  String username = "system";
  String password = "jin";

  public void connection()//连接数据
   {

    try
     {

      Class.forName("oracle.jdbc.driver.OracleDriver");
      con = DriverManager.getConnection(url, username,
        password);
      stmt = con.createStatement();
     } catch (Exception e)
     {
      System.out.println("驱动问题");
     }
   }

  public ResultSet find(String sql)//查询
   {
    try
     {
      rs = stmt.executeQuery(sql);
     } catch (Exception e)
     {
      System.out.println("查询问题");
     }
    return rs;

   }

  public void insert(String sql)//插入
   {
    try
     {
      stmt.executeUpdate(sql);
     } catch (Exception e)
     {
      System.out.println("插入问题");
     }
   }

  public void delete(String sql)//删除
   {
    try
     {
      stmt.executeUpdate(sql);
     } catch (Exception e)
     {
      System.out.println("删除问题");
     }
   }

  public void update(String sql)//更新
   {
    try
     {
      stmt.executeUpdate(sql);
     } catch (Exception e)
     {
      System.out.println("更新问题");
     }

   }

  public void close()//关闭
   {

    try
     {

      con.close();
      stmt.close();

     } catch (SQLException e)
     {

      e.printStackTrace();
      System.out.println("已经关闭");
     }

   }
 }

 

---

客户端调用!JDBC

package common;

import java.sql.ResultSet;
import java.sql.SQLException;

public class Client
 {

  /**
   * @param args
   *            查询删除实力
   */
  public static void main(String[] args)
   {
    /**
     * 查询模块
     */
    ResultSet rs = null;
    String sql = "select * from test";
    JDBC s = new JDBC();
    s.connection();
    rs = s.find(sql);
    try
     {
      while (rs.next())
       {
        System.out.println("学号" + rs.getString(2)
          + "姓名" + rs.getString(1));
       }
     } catch (SQLException e)
     {
      // TODO Auto-generated catch block
      e.printStackTrace();
      System.out.println("无查找内容");
     }
   
     /**
      * 添加模块
      */
     sql="insert into test values('小明','478')";
     s.insert(sql);
     /**
      * 更新模块
      */
     sql="update test set name='胡' where id='0615'";
     s.update(sql);
     /**
      * 删除模块
      */
    sql="delete from test where id='478'";
    /**
     * 关闭
     */
    
    s.close();
    
   }

 }
==========================