求一个oreacle的连接数据库的类 要完整的 导入包啊什么什么的 主要用来查询 修改功能 完整的 谢谢 哈 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 ORACLE 的DBHELPER网上有 http://www.cnblogs.com/wuya/archive/2009/09/17/1568414.htmlC#的 给个java版的 public static Connection getConnection() {// String user = "xxx";// String password = "xxx";// String url = "jdbc:oracle:thin:@[ip]:1521:[SID]"; Connection connection = null; try { Class.forName("oracle.jdbc.driver.OracleDriver"); connection = java.sql.DriverManager.getConnection(url, user,password); } catch (Exception e) { e.printStackTrace(); } return connection; } public static void getCount() throws SQLException { Connection connection = getConnection(); Statement statement = connection.createStatement(); String sql = "select count(*) from mgmt_entity"; ResultSet resultSet = statement.executeQuery(sql); while (resultSet.next()) { System.out.println("first:"+resultSet.getInt(1)); }// resultSet.close();// statement.close();// statement = connection.createStatement(); resultSet = statement.executeQuery(sql.replaceAll("mgmt_entity", "hm_login_info")); while (resultSet.next()) { System.out.println("second:"+resultSet.getInt(1)); } connection.close(); } java版的给我干嘛 不懂... 不过谢谢了 关于kill数据库进程的问题 数据库毕业设计 做个什么好呢 oracle的em启动不了 ORA-01017: invalid username/password; logon denied oracle中,设定varchar2长度为4000,(最大只能存4000),为什么存到1333就不行了,多一个都不行,报 ORA-01480:trailling 求数据库对象建立脚本 Oracle 9i 里面如何操作文件,高手近来呀。 (简单问题)怎么把数据导入oracle 在线等待:在exp,imp 中如何指定要操作的数据库 怎么在sql中删除主健? 为什么可以这样定义变量? oracle日期类型问题
网上有
C#的
// String user = "xxx";
// String password = "xxx";
// String url = "jdbc:oracle:thin:@[ip]:1521:[SID]";
Connection connection = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
connection = java.sql.DriverManager.getConnection(url, user,password);
} catch (Exception e) {
e.printStackTrace();
}
return connection;
} public static void getCount() throws SQLException {
Connection connection = getConnection();
Statement statement = connection.createStatement();
String sql = "select count(*) from mgmt_entity";
ResultSet resultSet = statement.executeQuery(sql);
while (resultSet.next()) {
System.out.println("first:"+resultSet.getInt(1));
}
// resultSet.close();
// statement.close();
// statement = connection.createStatement();
resultSet = statement.executeQuery(sql.replaceAll("mgmt_entity", "hm_login_info"));
while (resultSet.next()) {
System.out.println("second:"+resultSet.getInt(1));
}
connection.close();
}