用Borland JBuilder X Enterprise 连接到数据库,连接到ACCESS也行

来源:百度知道 编辑:UC知道 时间:2024/05/19 11:26:35

import java.sql.*;

public class TestOracleSel{
public static void main ( String[] args ){
Connection conn=null;
Statement stm=null;
ResultSet rs=null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@10.0.0.14:1521:cdfy";
String user="test";
String password="test";
String strsqlsel = "select * from test_wei";
int temp=0;
conn=DriverManager.getConnection(url,user,password);
stm=conn.createStatement();
rs=stm.executeQuery(strsqlsel);
if(rs.next()){
System.out.println("This SQL has ResultSet!");
do{
System.out.println(temp+++" true");
}
while(rs.next());
}
else
System.out.println("This SQL hasn't ResultSet!");
if(rs!=null)
rs.close();
if