package test;
import java.sql.*;
public class conn{
Connection connection = null ;
public conn(){ try{
//load the jdbc driver ;
String driverName = "oracle.jdbc.driver.OracleDriver";
Class.forName(driverName).newInstance();
//create a connection to the database;
String serverName = "10.10.21.112";
String serverPort = "1521:hnpost";
String serverID = serverName + serverPort ;
String userName = "admin";
String userPsw = "admin";
String url = "jdbc:oracle:thin:@" + serverID ;
Connection = DriverManager.getConnection(url , userName , userPsw);
}
catch(ClassNotFoundException e1)
{
}
}
}
import java.sql.*;
public class conn{
Connection connection = null ;
public conn(){ try{
//load the jdbc driver ;
String driverName = "oracle.jdbc.driver.OracleDriver";
Class.forName(driverName).newInstance();
//create a connection to the database;
String serverName = "10.10.21.112";
String serverPort = "1521:hnpost";
String serverID = serverName + serverPort ;
String userName = "admin";
String userPsw = "admin";
String url = "jdbc:oracle:thin:@" + serverID ;
Connection = DriverManager.getConnection(url , userName , userPsw);
}
catch(ClassNotFoundException e1)
{
}
}
}
解决方案 »
- 紧急求ibatis连接sql的sqlMapconfig.xml 和 SqlMap.properties 文件内容
- clob字段
- Java有经验没有经验的都应该看的问题
- for循环
- 在1亿条用户记录里,如何快速查询统计出看了5个电影以上的用户?
- 结束java程序的问题
- struts2 action 执行情况
- 哪位用过BEA的workshop8.1开发过比较大型的项目
- ??????????开发软件难吗?????????????????????????????????
- 求救整合ssh时,hibernate不能使用delete()方法,也无法执行删除语句
- struts 中 validation.xml
- 消息驱动Bean(MDB) 怎么才能够监听 远程 JBoss 服务器上的 一个 Topic 呢?
Class.forName("oracle.jdbc.driver.OracleDriver");
connectString = "jdbc:oracle:thin:@192.168.1.134:1521:zhpt";
conn = (OracleConnection)
DriverManager.getConnection(connectString, "dzjc","dzjc");
stmt = conn.createStatement();
stmt.executeUpdate("insert into dzjc_img(img) values (empty_blob())");
rs = stmt.executeQuery("select img from dzjc_img for update");
要的是这个?