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.
oracle jdbc链接
最新推荐文章于 2023-03-28 15:45:13 发布