oracle jdbc链接

来源：互联网发布：域名和商标的区别编辑：程序博客网时间：2024/06/06 16:55

package com.gg.oracle;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class TestOracleJdbc {public static void main(String[] args) {ResultSet rs=null;Statement s=null;Connection c=null;try {Class.forName("oracle.jdbc.driver.OracleDriver");c=DriverManager.getConnection("jdbc:oracle:thin:@localhost:8080:gg","root","root");s=c.createStatement();//插入//String sql=" insert into zhouhonglong(id,username,password)values(4,'zhoudage','dd')";//System.out.println(s.execute(sql));rs=s.executeQuery("Select * From zhouhonglong");while(rs.next()) {      System.out.println(rs.getString(1)+rs.getString(2)+rs.getString(3));     }  } catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {e.printStackTrace();}finally {     try {      if(rs != null) {       rs.close();       rs = null;      }      if(s != null) {       s.close();       s = null;      }      if(c != null) {       c.close();       c = null;      }     } catch (SQLException e) {      e.printStackTrace();     }    }  }}

遇到的问题，用plsql建完表，插入几行之后，运行代码一直查找不到，原因在plsql中没有commit.

0 0