import java.sql.*;
public class HelloJDBC {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
//第一步,建立驱动程序实例
Class.forName("oracle.jdbc.driver.OracleDriver");
//第二步,获得连接
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:oracle", "system", "pqx3318");
//第三步,获得Statement
Statement stmt = con.createStatement();
String sql = "select id,name from HelloJDBC";
//第四步,执行SQL语句
ResultSet rs = stmt.executeQuery(sql);
//处理结果集
while(rs.next()) {
int id = rs.getInt("id");
String name = rs.getString("name");
System.out.println("id: " + id + ", name: " + name);
}
//第六步s
rs.close();
stmt.close();
con.close();
}
}
用jdbc连oracle数据库
怎么弄咯
要设置环境变量吗
命令行和myeclipse里面分别怎么弄?
上面的程序错对了吗?为什么在我的机器上跑不起
谁能告诉我错在哪咯
谢谢拉