17,137
社区成员




package hwr.demo.example;
import java.sql.*;
public class ConnectDB {
public ConnectDB() {
// TODO Auto-generated constructor stub
}
public static void main(String[] args) {
// TODO Auto-generated method stub
// DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
try {
Class.forName("oracle.jdbc.OracleDriver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
String url = "jdbc:oracle:thin:@localhost:1521:hwr";
String userName = "scott";
String password = "tiger";
try {
// OracleDataSource dataSource = new OracleDataSource();
Connection conn = DriverManager.getConnection(url, userName, password);
Statement stmt = conn.createStatement();
ResultSet res = stmt.executeQuery("select * from dept");
while (res.next()){
System.out.println(res.getString(1));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}