访问远程的SQL:jdbc:microsoft:sqlserver://212.231.15.34:1433;DatabaseName=Test没错
访问远程的ACCESS数据库恐怕不行。ACCESS是桌面数据库没办法直接远程访问的。不过如果是局域网内的可以通过共享直接访问得到ACCESS的
公网的恐怕无能为力了。
访问远程的ACCESS数据库恐怕不行。ACCESS是桌面数据库没办法直接远程访问的。不过如果是局域网内的可以通过共享直接访问得到ACCESS的
公网的恐怕无能为力了。
解决方案 »
- 菜鸟求教
- 怎么设置多个<td>标签的宽度
- webservice中转问题
- hibernate 存储过程出错
- 想学j2ee的东西
- 高手指教:关于struts+spring+hibernate 数据传输问题
- struts问题请教
- android如何实现在任意activity包括桌面弹出一个对话框??
- jbuilderx tomcat5 运行一下TOMCAT5没有启动起来,很短时间就终止了。
- struts问题?网上等,急!!!!!!!!!!!!!
- hibernate 查询
- 用TOMCAT发布的时候在webapps底下放一个.jsp文件,浏览器里面输http://localhost;8080/*.jsp就抱错
可以,只要那边服务器是开着的,数据库开着的
你在连接时IP地址写对就可以
Access我没试过呢
/**
* A JDBC test application for Sybase
* @author dingting
* @version 1.0.0
* @since JDK1.4
*/
package tf.dt.credit.database;
import java.sql.*;
import tf.dt.credit.database.JNDINames;
public class odbcConnection {
private final String sybaseDriverName = JNDINames.CLASSFORNAME;
private final String sybaseUrlToConnect =JNDINames.SERVANDDB; private Connection myConnection = null;
/**
* To load the jdbc driver
*
*/
public odbcConnection()
{
try
{
Class.forName(sybaseDriverName);
}catch(ClassNotFoundException ex)
{
System.out.println(getErrorMessage(ex,"The Driver loaded error,please contact to your Software Designer!").toString());
}
} public StringBuffer getErrorMessage(Exception ex,String alarmMessage)
{
StringBuffer errorStringBuffer = new StringBuffer();
errorStringBuffer.append(alarmMessage);
errorStringBuffer.append(ex.getMessage());
return errorStringBuffer;
} /**
* getConnection method
* @return Connection
*/
public Connection getConnection()
{
try
{
this.myConnection = DriverManager.getConnection(sybaseUrlToConnect,JNDINames.USER,JNDINames.PWD); }catch(Exception ex)
{
System.out.println(getErrorMessage(ex,"Can not get connection,please contact to your Software Designer!").toString());
} return this.myConnection;
} /**
* @author:
* @function: UC表中取前一个交易日期的年月日。
* @return String
* @param: 无
*/
public String getLastDate() {
odbcConnection mySybaseTest = new odbcConnection();
String sDate = "";//得到当前账务日期
Statement stmt=null;
Connection conndb=null;
try {
conndb = mySybaseTest.getConnection();
String readStr ="SELECT SYDT FROM UC WHERE PMKY='ACNT' AND PMNM='ACLD'";
stmt = conndb.createStatement();
ResultSet rs = stmt.executeQuery(readStr); if (rs.next()) {
sDate = rs.getString(1);
sDate = sDate.substring(0, 4) + sDate.substring(5, 7) +sDate.substring(8, 10);
}
//System.out.println("得到当天账务日期-->"+sDate);
}
catch (Exception e) {
e.printStackTrace();
}
finally {
try {
conndb.close();
}
catch (Exception e) {
}
}
return sDate;
} /**
* @param args
* 测试用例
*/
/* public static void main(String[] args) {
odbcConnection mySybaseTest = new odbcConnection();
try
{
String strDate=mySybaseTest.getLastDate();
System.out.println("-->strDate:"+strDate); Connection myConnection = mySybaseTest.getConnection(); System.out.println("Now begin to excute............."); PreparedStatement myPreparedStatement = myConnection.prepareStatement("select * from UU where USID='C0123'"); ResultSet myResultSet = myPreparedStatement.executeQuery();
StringBuffer myStringBuffer = new StringBuffer(); while(myResultSet.next())
{
myStringBuffer.append(myResultSet.getString(1)+" ");
} System.out.println(new String(myStringBuffer.toString().getBytes("ISO-8859-1"),"GBK"));
}catch(Exception ex)
{
System.out.println(mySybaseTest.getErrorMessage(ex,"Application error,please contact to your Software Designer!").toString());
} /*运行结果
得到当天账务日期-->20081217
-->strDate:20081217
Now begin to excute.............
C0123
* /
}
*/
}====
package tf.dt.credit.database;public interface JNDINames {
final String CLASSFORNAME = "com.sybase.jdbc3.jdbc.SybDriver";
final String SERVANDDB = "jdbc:sybase:Tds:192.168.1.72:4100/bankdb?charset=cp850&jconnect_version=3";
final String USER = "sa";
final String PWD = "******";
}
楼主完成请转发一份,谢谢。[email protected]