springboot+jdbc实现oracle数据库连接
1.pom文件
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
2.jdbc连接数据库(不是工厂模式,只是单次连接)
数据库连接配置,可以通过配置类注入
private static String driver = "oracle.jdbc.driver.OracleDriver";
private static String url = "jdbc:oracle:thin:@127.0.01:1521:orcl";
private static String user = "SCOTT";
private static String password = "TIGER";
定义Connection 和PreparedStatement
private Connection conn;
private PreparedStatement st;
//获取连接
Class.forName(driver);
conn = DriverManager.getConnection(url, user, password);
//定义sql
String sql = "select * from student where sname <> ?";
//预加载
st = conn.prepareStatement(sql);
//对问好进行赋值
st.setString(1,"xiao");
//进行查询并接受
ResultSet rs = st.executeQuery();
//对结果进行处理
while (rs.next()) {
String name = rs.getString("sname");
System.out.println(name);
}
执行完毕后需要进行资源关闭