1.打开IDEA,点击Datebase,点击加号
2.选择Datasoure,选择oracle
3.Driver选择Oracle(如果没有自己根据提示下载驱动)SID:自己的数据库名称,Port:端口号,再输入密码和用户名进行Test Connection,显示Successful即可点击确定,表示连接成功。
4.新建项目,并输入代码测试:
新建项目后,点击文件–>项目结构---->模块----->依赖,点击右边的+找到驱动文件(ojdbc6.jar)
(驱动文件位置查看方法:
点击Oracle,将鼠标放置在红圈里的图标上,就会显示
)
5.输入代码测试:
import java.sql.*;
import java.sql.DriverManager;
import java.sql.SQLException;
public class Test {
public static String driverClass = "oracle.jdbc.driver.OracleDriver";//加载Oracle驱动
public static String url = "jdbc:oracle:thin:@localhost:1521:XE";
public static String user = "AHUT";
public static String password = "ahut";
public static Connection getconn(){
Connection conn = null;
try {
Class.forName(driverClass);
conn = DriverManager.getConnection(url,user,password);
System.out.println("连接成功");
}catch (Exception e){
e.printStackTrace();
}
return conn;
}
public static void main(String[] args){
//测试驱动是否加载成功,以及是否连接到数据库
Test.getconn();
//测试能否用查询
Statement st = null;
ResultSet rs = null;
try {
st = Test.getconn().createStatement();
rs = st.executeQuery(“SELECT * FROM S”);
while (rs.next()){
System.out.print(rs.getString(“SNO”));
System.out.print(rs.getString(“SNAME”));
System.out.print(rs.getString(“SSEX”));
System.out.print(rs.getString(“SAGE”));
System.out.print(rs.getString(“SDEPT”));
System.out.println();
}
} catch (SQLException e) {
e.printStackTrace();
}
try {
Test.getconn().close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}