在idea中创建@TSET类测试druid数据库连接池,执行结果拒绝访问
public class tb_brand {
@Test
public void testQuery() throws Exception {
//1.导入jar包
//2.定义配置文件
//3. 加载配置文件
Properties prop=new Properties();
prop.load(new FileInputStream("C:\\Users\\Administrator\\IdeaProjects\\jdbc\\jdbc-demo"));
//4. 获取连接池对象 固定对象DruidDataSourceFactory
DataSource dataSource = DruidDataSourceFactory.createDataSource(prop);
//5. 获取数据库连接 Connection
Connection connection = dataSource.getConnection();
//System.out.println(connection); //获取到了连接后就可以继续做其他操作了
//6.定义SQL语句
String sql ="select *from tb_brand";
//7.获取pstmt对象
PreparedStatement pstmt = connection.prepareStatement(sql);
//8.设置参数
//9.执行sql语句
ResultSet rs = pstmt.executeQuery();
ArrayList brands=new ArrayList<>();
while (rs.next()){
int id=rs.getInt("id");
String brandName=rs.getString("brand_name");
String companyName = rs.getString("company_name");
int ordered = rs.getInt("ordered");
String description = rs.getString("description");
int status = rs.getInt("status");
Brand brand=new Brand(id,brandName,companyName,ordered,description,status);
brands.add(brand);
}
System.out.println(brands);
}
}
java.io.FileNotFoundException: C:\Users\Administrator\IdeaProjects\jdbc\jdbc-demo (拒绝访问。)
at java.io.FileInputStream.open0(Native Method)
at java.io.FileInputStream.open(FileInputStream.java:195)
at java.io.FileInputStream.(FileInputStream.java:138)
at java.io.FileInputStream.(FileInputStream.java:93)
at com.itheima.com.itheima.example.tb_brand.testQuery(tb_brand.java:24)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56)
at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
at org.junit.runners.BlockJUnit4ClassRunner$1.evaluate(BlockJUnit4ClassRunner.java:100)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:366)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:103)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:63)
at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329)
at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293)
at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
at org.junit.runners.ParentRunner.run(ParentRunner.java:413)
at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69)
at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:33)
at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:235)
at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:54)
Disconnected from the target VM, address: '127.0.0.1:61945', transport: 'socket'
Process finished with exit code -1
刚入门,所以没有方向
请问是否跟权限有关,需要更改什么配置
账号权限问题,账号的配置的访问host配置改成*所有可以访问,其次账号也要开对应的操作权限