可以用jdbc-odbc桥连接 在windows下
---
import="java.sql.*"
Connection con=null;
Statement sql=null;
ResultSet rs=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){ out.print("jdbcodbc 连接错误");}
try{
con=DriverManager.getConnection("jdbc:odbc:wwh","",""); 中的wwh是odbc中用户创建的数据源名称。
sql=con.createStatement();
}catch(SQLException e){out.print(" sql error");}
你自己看一下吧:package query;
import java.sql.*;
public class query2
{ String sDBDriver="org.postgresql.Driver";
String sConnStr="jdbc:postgresql://192.168.123.201:5432/service";
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
String password="11111111";
String user="postgres";
String flag="0";
public query2()
{try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e){
System.err.println("query2()"+e.getMessage());
}
}
public ResultSet executeQuery(String sql)
{rs=null;
try
{
conn=DriverManager.getConnection(sConnStr,user,password);
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}catch (SQLException ex)
{
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return rs;
}
public void executeUpdate(String sqlAlter)
{
stmt=null;
rs=null;
try
{
conn=DriverManager.getConnection(sConnStr,user,password);
stmt=conn.createStatement();
int recoder=stmt.executeUpdate(sqlAlter);
}
catch(SQLException ex)
{
System.err.println("aq.executeUpdate:"+ex.getMessage());
}
flag="1";
}
public String getFlag(){
return flag;
}
public void reset() {
flag="0"; }
}
帮你顶吧!
自己up吧。
自己up吧
自己up吧