javaJDBC连接BaseDao

最新推荐文章于 2024-09-20 15:32:13 发布

iteye_2837

最新推荐文章于 2024-09-20 15:32:13 发布

阅读量113

点赞数

文章标签： java 数据库

本文链接：https://blog.csdn.net/iteye_2837/article/details/82603622

版权

final String DRIVER="oracle.jdbc.OracleDriver";
final String URL="jdbc:oracle:thin:@localhost:1521:orcl";
final String NAME="scott";
final String PASSWORD="tiger";
protected Connection con;
protected PreparedStatement pst;
protected Statement st;
protected ResultSet rs;
//连接数据库

public Connection getConnection(){
try {
Class.forName(DRIVER);
con=DriverManager.getConnection(URL, NAME, PASSWORD);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}

return con;
}
//关闭资源
public boolean closeNews(){
if(rs!=null)
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return false;
}
if(st!=null)
try {
st.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return false;
}
if(pst!=null)
try {
pst.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return false;
}
if(con!=null)
try {
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return false;
}
return true;
}
}