以下是我的java程序段:import java.sql.*;
import java.math.*;public class Employee {
public static void main(String[] args)
throws SQLException
{
try {
System.out.println("welcome");
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
System.out.println("register driver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@10.0.7.210:1521:Test","scott","tiger");
System.out.println("connection succeed!!");
Statement stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery("select ENAME from EMP");
while(rset.next())
System.out.println(rset.getString(1));
} catch (SQLException e) {
e.printStackTrace();
throw new SQLException();
}
}
}
import java.math.*;public class Employee {
public static void main(String[] args)
throws SQLException
{
try {
System.out.println("welcome");
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
System.out.println("register driver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@10.0.7.210:1521:Test","scott","tiger");
System.out.println("connection succeed!!");
Statement stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery("select ENAME from EMP");
while(rset.next())
System.out.println(rset.getString(1));
} catch (SQLException e) {
e.printStackTrace();
throw new SQLException();
}
}
}
另外,Test是SID啊
我怀疑是oracle配置这一端有问题,但由于我是新手,忙了几天都没结果
请各位高手帮帮忙,指点指点阿
tnsnames.ora,listener.ora,sqlnet.ora 的书写有关系吗?
正确的该怎么写啊??