import java.sql.*;
public class Jdbc{
private static String Driver = "oracle.jdbc.driver.OracleDriver"; //加载jdbc连接oracle的驱动包
private static String url = "jdbc:oracle:thin:@127.0.0.1:1521:Exercise"; //连接数据库的url注意:<span style="background-color: rgb(255, 0, 0);">thin后面的冒号、端口号、末尾不要加分号</span>
private static String root = "scott"; //数据库登录用户名
private static String pwd = "tiger"; //登录密码
/**
*获取数据库连接
*/
private static Connection conn;
public static Connection getConnection(){
try{
Class.forName(Driver);
conn = DriverManager.getConnection(url,root,pwd);
}catch(ClassNotFoundException e){
e.printStackTrace();
}catch(SQLException e){
e.printStackTrace();
}
return conn; //返回数据库连接
}
/**
*关闭数据库连接
*/
public static void closeConnection(Connection conn){
try{
conn.close();
}catch(SQLException e){
e.printStackTrace();
}
}
public static void main(String arg[]){
Connection conn = Jdbc.getConnection();
String sql = "select * from person";
try{
PreparedStatement pstm = conn.prepareStatement(sql);
ResultSet res = pstm.executeQuery();
while(res.next()){
String name = res.getString("username");
System.out.println(name);
}
}
catch(SQLException e){
e.printStackTrace();
}
}
}
下面附上连接数据库的驱动