jdbc 连接oracle数据库异常

Question

try 
{
//1.加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
System.out.println("加载驱动成功");
//2,得到连接
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:127.0.0.1:1521:testOracle", "scott", "123456");
// Connection conn = DriverManager.getConnection("jdbc:oracle:thin:127.0.0.1:1521:myora1","scott", "123456");
System.out.println("连接成功!");

Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("select * from emp");

while(rs.next())
{
System.out.println("用户名："+rs.getString("ename"));
}

}
catch(Exception e)
{
e.printStackTrace();
}
java.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092352)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:404)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.oracle0809.TestOracle2.main(TestOracle2.java:15)

Answer 1

jdbc:oracle:thin:@127.0.0.1:1521:testOracle

Answer 2

错误：jdbc:oracle:thin:127.0.0.1:1521:testOracle正确：jdbc:oracle:thin:@127.0.0.1:1521:testOracle

Answer 3

jdbc:oracle:thin:@127.0.0.1:1521:testOracle

Answer 4

Class.forName("oracle.jdbc.driver.OracleDriver");
connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "tiger");
st = connection.createStatement();少个@