我现在需要连接服务器上的oracle数据库,我需要知道些什么信息呢???
如果知道这些信息,我直接写上代码,就能连吗???
如果知道这些信息,我直接写上代码,就能连吗???
解决方案 »
- a4j验证后提交表单
- onclick="window.open......传递参数问题 (Struts2)
- org.springframework.orm.hibernate3.HibernateQueryException: could not locate nam
- struts2 整合 hibernate spring 启动tomcate 6报错.(在另一个机器上正常无误)
- oracle的java.sql.SQLException: Io 异常 The Network Adapter could not establish the connection
- jquery表单验证插件验证用户名是否存在的例子,remote里面错了,就教?
- 取路径问题
- 怎样在浏览器首次加载图片时获得正确的图片长宽?
- 我下载了 JBuilder但是它要序列号,麻烦高手帮忙弄一个,请高手指路!
- 怎么数据库有时可以加入数据有时不行呢?
- MyEclipse启动tomcat的时候出现错误
- 框架怎么学?
public static void main(String args[]) throws Exception{
//利用Oracle驱动进行连接
Class.forName("oracle.jdbc.driver.OracleDriver");//载入驱动
String url = "jdbc:oracle:thin:@localhost:1521:SCHOOL";
Connection conn = DriverManager.getConnection(url,"scott","tiger");
Statement stat = conn.createStatement();
ResultSet rs = stat.executeQuery("SELECT 姓名 FROM 学籍");
while(rs.next()){
System.out.println(rs.getString("姓名"));
}
}
}
然後試著ping一下數據庫所在的ip,
如果能ping通,就跟平時的一樣連接。
Connection conn = DriverManager.getConnection(url,username,password);
url:
数据库所在机子IP:10.224.2.153
端口:1521
数据库名:SCHOOL
连接用户名:username
连接密码:password
private Connection conn=null;
private PreparedStatement prep=null;
private ResultSet re=null;
private String dir="oracle.jdbc.OracleDriver";
private String url="jdbc:oracle:thin:@localhost:1521:ACCP";
private boolean flag=false;
public Connection getConn(){
try {
Class.forName(dir);
conn=DriverManager.getConnection(url,"scott","tiger");
} catch (ClassNotFoundException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
return conn;
}
//修改
public boolean update(String stuid,String name){
getConn();
try {
prep=conn.prepareStatement("update stu set stuname=? where stuid=?");
prep.setString(1, name);
prep.setString(2, stuid);
int r=prep.executeUpdate();
if(r>0){
flag=true;
}
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}finally{
close();
}
return flag;
}
//插入
public boolean insert(String stuid,String name){
getConn();
try {
prep=conn.prepareStatement("insert into stu values(?,?)");
prep.setString(1, stuid);
prep.setString(2, name);
int r=prep.executeUpdate();
if(r>0){
flag=true;
}
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}finally{
close();
}
return flag;
}
//查询
public void query(){
getConn();
try {
prep=conn.prepareStatement("select * from stu");
re=prep.executeQuery();
while(re.next()){
System.out.println("学号为:"+re.getString(1));
System.out.println("姓名为:"+re.getString(2));
}
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}finally{
close();
}
}
public void close(){
if(re!=null){
try {
re.close();
re=null;
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
if(prep!=null){
try {
prep.close();
prep=null;
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
if(conn!=null){
try {
conn.close();
conn=null;
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
}
public static void main(String []age){
ConnDB db=new ConnDB();
// if(db.insert("1002", "张三")){
// System.out.println("插入成功!");
// }
if(db.update("1002", "李四")){
System.out.println("修改成功!");
}
db.query();
}}
private static Connection conn;
public static Connection getConnection(){
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:testDB", "gygc", "fred");
}
catch(ClassNotFoundException ex){
System.out.println("类未发现异常");
ex.printStackTrace();
}
catch(SQLException ex){
System.out.println("SQL异常");
ex.printStackTrace();
}
return conn;
}}
同时要将oracle中的classes12.jar和nls_charset12.jar拷过来
private void init() {
try{
Context ctx = null;
Properties p = new Properties();
p.put(Context.INITIAL_CONTEXT_FACTORY,"weblogic.jndi.WLInitialContextFactory"); String Weblogic_URL="t3://localhost:7001"; //WebLogic Server domain URL
String Weblogic_JNDI="****"; //Weblogic JNDI Name
String Weblogic_User="****"; //WebLogic Server domain配置控制台用户
String Weblogic_Pwd="12345678"; //weblogic用户密码
p.put(Context.PROVIDER_URL, Weblogic_URL);
p.put(Context.SECURITY_PRINCIPAL,Weblogic_User);
p.put(Context.SECURITY_CREDENTIALS,Weblogic_Pwd);
ctx = new InitialContext(p);
DataSource ds = (DataSource)ctx.lookup(Weblogic_JNDI);
conn = ds.getConnection(); //得到connection对象
}
catch(Exception e){e.printStackTrace();}
}
public class ConnectionOracle {
public static void main(String[] args) {
String DBDriver = "oracle.jdbc.driver.OracleDriver";
String DBLocation = "jdbc:oracle:thin:@61.172.*.*:1521:orcl";
String DBUser = "***";
String DBPwd = "***";
try {
Class.forName(DBDriver);//载入驱动
System.out.println("********");
Connection conn = DriverManager.getConnection(DBLocation, DBUser, DBPwd);
System.out.println("*************");
String sql = "select * from e3data.tab_文件管理表";
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs=ps.executeQuery();
while(rs.next()){
System.out.println(rs.getInt(1));
}
} catch (ClassNotFoundException e) {
System.out.println(e);
} catch (SQLException e) {
// TODO Auto-generated catch block
System.out.println(e);
}
}}驱动过了,但是建立连接的时候报错java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection