jdbc连接oracle 我用的编译工具是myeclipse 6.5

[xiaoziyang09102]

编译没显示错误，oracle里面并没有更新数据，sql语句也没打印出来，
我用的编译工具是myeclipse 6.5，
新手求解答，谢谢！
源代码如下：
import java.sql.*;

public class TestDML2 {

public static void main(String[] args) {
Statement stmt = null;
Connection conn = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(
"jdbc:oracle:thin@118.239.51.106:1521:orcl", "scott", "tiger");
stmt = conn.createStatement();
String sql = "insert into dept2 values(99, 'GAME', 'CD')";
System.out.println(sql);
stmt.executeUpdate(sql);
} catch (ClassNotFoundException e) {
e.getStackTrace();
} catch (SQLException e) {
e.getStackTrace();
}finally{
try{
if(stmt != null){
stmt.close();
}if(conn != null){
conn.close();
}
}catch (SQLException e){
e.getStackTrace();
}
}
}

}

[zhangjian0410]

打个断点自己试试就行了。

[mon213]

jdbc:oracle:thin@118.239.51.106:1521:orcl", "scott", "tiger");

你这句写错了

应该是这样才对jdbc:oracle:thin:@118.239.51.106:1521:orcl", "scott", "tiger");

[啊彪123]

ls真仔细，应该去做测试！

[guo624587253]

打个断点自己试试就行了，问题不就是出来啦吗

[wangming19]

可是我这个为什么错啊？老师，源码如下：
public static final String DRIVER="oracle.jdbc.driver.OracleDriver";
public static final String URL="jdbc:oracle:thin:@localhost:1521:STUDENT";
public static final String USER="xiaoming";
public static final String PASS="m123";

public Connection getConn(){
Connection conn=null;
try {
Class.forName(DRIVER);
} catch (ClassNotFoundException e) {
// TODO: handle exception
System.out.println("数据库驱动错误");
}
try {
conn=DriverManager.getConnection(URL,USER,PASS);
} catch (SQLException e) {
// TODO: handle exception
System.out.println("数据库连接错误");
}
return conn;
}