用java怎么连sybase数据库

[MSER]

[fufupp]

要有jdbc与sybase数据库的驱动

[MSER]

怎么用呀,我下载了jconnect5-5驱动,但不知怎么连呀?

[leeke45]

有文档

[zych72]

首先，你把驱动程序家如classpath
然后试试下面代码


import java.sql.*;
import java.util.*;


public class TestSybDB {
public static void main (String args[])throws Exception{

String url="jdbc:sybase:Tds:192.168.0.12:5000/BauschLomb";
Properties info = new Properties();


info.setProperty("driver", "com.sybase.jdbc2.jdbc.SybDriver");
info.setProperty("user","sa");
info.setProperty("password","password");
info.setProperty("CHARSET","cp936");

Connection conn=null;
ResultSet rs = null;
try {
conn=DriverManager.getConnection(url,info);

conn.setAutoCommit(true);
CallableStatement csmt = conn.prepareCall("{call aa(?,?)}");
csmt.setString(1,"temp1mbb.txt");
csmt.registerOutParameter(2,java.sql.Types.VARCHAR);
rs=csmt.executeQuery();
System.out.print(csmt.getString(2));
while(rs.next()){
System.out.print(rs.getString(1));
}
}catch(SQLException ex) {
System.err.println("执行SQL语句出错：" + ex.getMessage());
throw ex;
}
conn.close();
}

}

[zych72]

你的数据库明、用户、密码、服务器地址可能与上面的 不同，清自己修改