java新手请教：jdbc连接问题
程序如下：但为何还是提示错误？？
package com.tarena;
import java.sql.*;
public class TestCallableStmt {
static Connection conn = null;
//注冊驱动有在其他程序测试过是OK的
static {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
conn = DriverManager.getConnection(url, "scott", "1234");
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
callSpWithoutOutParam();
}
public static void callSpWithoutOutParam() {
//过程名：insert_stu,表名：student(列名分别为：id, name, age, sex)
String sql = "{call insert_stu(?, ?, ?, ?)}";
try {
CallableStatement callStmt = conn.prepareCall(sql);
callStmt.setInt(1,2);
callStmt.setString(2,"Peko");
callStmt.setInt(3, 24);
callStmt.setString(4,"M");
callStmt.execute();
}catch (SQLException e) {
e.printStackTrace();
}
}
}
JDBC
[解决办法]
没有把你的驱动加到classpath
[解决办法]
你没把orcal驱动包导入吧
[解决办法]
缺少驱动包。。。。
[解决办法]
下个ojbc.jar 放lib下
[解决办法]
没有把包导进去吧啊
