import java.sql.*;
public class TestOracle {
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
String className="oracle.jdbc.OracleDriver";
String url="jdbc:oracle:thin:@chen:1521/orcl";
//jdbc:oralce:thin://@192.168.16.240:1521:orcl
//jdbc:oracle:thin:@chen:1521/orcl
public void link(){
try {
Class.forName(className);
conn=DriverManager.getConnection(url,"chenlong","394401");
System.out.println("Connect Success!!!");
} catch (Exception e) {
e.printStackTrace();
System.out.println("Connect Fail!!!");
}
String sql="select * from test";
try {
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
ResultSetMetaData rm=rs.getMetaData();
System.out.println("===============");
while(rs.next()){
for(int i=1;i<=rm.getColumnCount();i++){
System.out.print(rs.getObject(i)+" ");
}
System.out.println("\n");
}
System.out.println("\n===============");
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
TestOracle chen=new TestOracle();
chen.link();
}
}
哈哈,过来看看你,虽然扯不上关系啊