package wlj;
import java.sql.*;
public class textwlj {
public static void main(String[] args) throws ClassNotFoundException{
try {
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
} catch (Exception e) {
e.printStackTrace();
}
//orcale 12c 的数据库url
//String url="jdbc:oracle:thin:@192.168.1.250:
1522/pdborcl"; 注意。。。。。端口和数据库名称的链接不一样
/
pdborcl
//orcale 11g 的数据库url
//String url="jdbc:oracle:thin:@192.168.1.250:
1521:orcl";注意。。。。。端口和数据库名称的链接不一样
：
orcl
String url="jdbc:oracle:thin:@192.168.1.250:1521/pdborcl";
//orcl为你的数据库的SID
String user="pdsci";
String password="123456";
Connection conn = null;
Statement stmt = null;
try {
conn = DriverManager.getConnection(url, user, password);
stmt = conn.createStatement();
} catch (SQLException e) {
e.printStackTrace();
}
String sql="select * from AID_PROJ where ROWNUM <=5";
ResultSet rs = null;
try {
rs = stmt.executeQuery(sql);
while (rs.next()) {
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
//rs.getString(1);
//rs.getString(2);
}
} catch (SQLException e) {
e.printStackTrace();
}
System.out.print("数据库操作成功，恭喜你");
try {
rs.close();
stmt.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
转载请注明原文地址: https://ju.6miu.com/read-1309381.html
