orcla jdbc 连接的例子 谁有???我忘记了 急用!!!100分 数据库名tct108用户名site_test密码.......速度给分 成信!!!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Class.forName( "oracle.jdbc.driver.OracleDriver" ); Connection cn = DriverManager.getConnection( "jdbc:oracle:thin:@MyDbComputerNameOrIP:1521:ORCL", sUsr, sPwd ); Class.forName( "oracle.jdbc.driver.OracleDriver" ); cn = DriverManager.getConnection( "jdbc:oracle:thin:@MyDbComputerNameOrIP:1521:tct108", "site_test", "......");MyDbComputerNameOrIP 替换你的oracle数据库ip地址 public static void main(String[] args) { Connection conn = null; try { Class.forName("oracle.jdbc.driver.OracleDriver"); conn = DriverManager.getConnection( "jdbc:oracle:thin:@localhost:1521:tct108", "site_test", "..."); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { if (conn != null) try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } public class dbmanger { private String driver="oracle.jdbc.driver.OracleDriver"; private String user="site_test "; private String password=""; private String url="jdbc:oraclethin:@MyDbComputerNameOrIP/tct108"; private Connection con=null; public dbmanger() { try { Class.forName(driver); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } try { con=DriverManager.getConnection(url, user, password); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public Connection getConnection() { if(con==null) { try { con=DriverManager.getConnection(url,user,password); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return con; } public void close(){ if(con!=null) { try { con.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }} 怎么用java把二进制的数据存到oracle阿?? 把本地硬盘里的图片存储到oracle数据库里blob的实现 public static void main(String[] args) { Connection conn = null; try { Class.forName("oracle.jdbc.driver.OracleDriver"); conn = DriverManager.getConnection( "jdbc:oracle:thin:@localhost:1521:tct108", "site_test", "..."); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { if (conn != null) try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } 乐观锁问题。。。 java 虚拟机和 浏览器 [紧急][在线等]请问htmlparser中有没对应所有html标签的过滤器~?谢谢~[解决立刻结帖] spring问题,加载成功以后,运行一段时间以后,出现加载失败? 问个有关include 的问题 急~~~~~~~~~在线等~~~~~~~~~~~~~~~~~~~~~ 急!!各位大哥哥快点帮帮小MM吧! ActionContext.PARAMETERS 向高手求救,关于jsp调用dll组件的问题 BEAN操作数据库错误。 Session问题 从JAVA中怎样获得JSP中select中的值?
Connection cn = DriverManager.getConnection( "jdbc:oracle:thin:@MyDbComputerNameOrIP:1521:ORCL", sUsr, sPwd );
cn = DriverManager.getConnection( "jdbc:oracle:thin:@MyDbComputerNameOrIP:1521:tct108", "site_test", "......");MyDbComputerNameOrIP 替换你的oracle数据库ip地址
public static void main(String[] args) {
Connection conn = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:tct108", "site_test",
"...");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
if (conn != null)
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public class dbmanger {
private String driver="oracle.jdbc.driver.OracleDriver";
private String user="site_test ";
private String password="";
private String url="jdbc:oraclethin:@MyDbComputerNameOrIP/tct108";
private Connection con=null;
public dbmanger() {
try {
Class.forName(driver);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
con=DriverManager.getConnection(url, user, password);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public Connection getConnection() {
if(con==null) {
try {
con=DriverManager.getConnection(url,user,password);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return con;
}
public void close(){
if(con!=null) {
try {
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
Connection conn = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:tct108", "site_test",
"...");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
if (conn != null)
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}