jdbc步骤基本步骤
main中尽量不要出现底层代码
可以选择mysql或者oracle数据库连接
jar包为
在项目目录下创建 jars目录,把jar包复制进去然后右键点击build path即可
1.注册驱动进入内存
Class.forName("oracle.jdbc.driver.OracleDriver");
Class.forName("com.mysql.jdbc.Driver");
2.获取链接
Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@localhost:1521:orcl","ltw","ltw");
connection conn= DriverManager.getConnectio
("jdbc:mysql://localhost:3306/test?characterEncoding=utf8","root","root");
3.编写sql语句
String sql = "select * from student ";
4.创建执行语句
Statement st = conn.createStatement();
5.执行sql
ResultSet rs = st.executeQuery(sql);//使用结果集接收
6.关闭资源
资源的关闭要注意,若与try/catch在同一函数中,一定要放在finally中
否则数据量大时会引起数据库的崩溃
此处我使用工具类进行封装,以便复用
public static void closeAll(ResultSet rs, Statement st,Connection conn){
try {
if(rs!=null)
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
if(st!=null)
st.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
if(conn!=null)
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
遍历结果集
表结构为
while (rs.next()) {
String name = rs.getString("name");
String id = rs.getString("stuno");
BigDecimal age = rs.getBigDecimal("age");
BigDecimal height = rs.getBigDecimal("height");
System.out.println(id + " " + name + " " + age + " " + height);
}
//Oracle中number类型获得的均为BigDecimal类型