public class UserDAO {
private Connection conn = null;
private Statement st = null;
public UserDAO() {
try {
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
conn = DriverManager
.getConnection
("jdbc:oracle:thin:@192.168.1.107:1521:ZHUH",
"zucc","123456");
} catch (Exception ex) {
ex.printStackTrace();
}
}public synchronized void release() {
if (st != null) {
try {
st.close();
} catch (Exception e) {
}
}if (conn != null) {
try {
conn.close();
} catch (Exception e) {
}
}}
public synchronized boolean checkuser(ActFrmUsers user) throws Exception{
boolean bl=false;
try{
st = conn.createStatement();//这句话放这里
ResultSet rs=st.executeQuery("select * from users");
while(rs.next()){
System.out.print("qw");
}
}
catch(Exception ex){
ex.printStackTrace();
throw new Exception("数据库查询错误");
}
return bl;
}
}
SpringBoot测试配置属性与web启动环境解析
vue中将el-switch值true、false改为number类型的1和0解析
Vue中的路由配置项meta使用解读
SpringBoot自定义bean绑定解析
SpringBoot常用计量与bean属性校验和进制数据转换规则解析
工厂方法在Spring框架中的运用介绍