请教:在java中采用哪种驱动连接可以访问到远程服务器上的sqlServer数据库 驱动程序有错,把驱动程序放LIB目录或加进CLASSPATH里。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 代码如下: package sms;import java.sql.*;public class TestData{ Connection con; Statement st; ResultSet rs; public TestData() { try { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); con = DriverManager.getConnection("jdbc:microsoft:sqlserver://服务器IP:1433;DatabaseName=服务器SQLServer数据库名","sa","23"); st = con.createStatement(); } catch (Exception e) { System.out.println("DriverExcepion:" + e.getMessage()); } } public ResultSet executeQuery(String sql) { rs = null; try { rs = st.executeQuery(sql); } catch (SQLException ex) { System.out.println("executeQuery :" + ex.getMessage()); System.out.println("sql=" + sql); } return rs; } public static void main(String args[]) { String time=""; TestData td = new TestData(); String sql="select recv_time from sms_recv where id=100"; //sms_recv为服务器上的表名 try { ResultSet rs2 = td.executeQuery(sql); while(rs2.next()) { time=rs2.getString("recv_time"); System.out.println("time ="+time); } rs2.close(); } catch(Exception e) { e.printStackTrace(); } finally { td = null; } }}异常:C:\JBuilder9\jdk1.4\bin\javaw -classpath "E:\bovey\prog\lhyd\classes;C:\JBuilder9\thirdparty\jakarta-tomcat-4.0.6-LE-jdk14\common\lib\servlet.jar;C:\JBuilder9\jdk1.4\demo\jfc\Java2D\Java2Demo.jar;C:\JBuilder9\jdk1.4\demo\plugin\jfc\Java2D\Java2Demo.jar;C:\JBuilder9\jdk1.4\jre\lib\charsets.jar;C:\JBuilder9\jdk1.4\jre\lib\ext\dnsns.jar;C:\JBuilder9\jdk1.4\jre\lib\ext\ldapsec.jar;C:\JBuilder9\jdk1.4\jre\lib\ext\localedata.jar;C:\JBuilder9\jdk1.4\jre\lib\ext\sunjce_provider.jar;C:\JBuilder9\jdk1.4\jre\lib\im\indicim.jar;C:\JBuilder9\jdk1.4\jre\lib\jaws.jar;C:\JBuilder9\jdk1.4\jre\lib\jce.jar;C:\JBuilder9\jdk1.4\jre\lib\jsse.jar;C:\JBuilder9\jdk1.4\jre\lib\rt.jar;C:\JBuilder9\jdk1.4\jre\lib\sunrsasign.jar;C:\JBuilder9\jdk1.4\lib\dt.jar;C:\JBuilder9\jdk1.4\lib\htmlconverter.jar;C:\JBuilder9\jdk1.4\lib\tools.jar" sms.TestData java.lang.NullPointerException at sms.TestData.executeQuery(TestData.java:29) at sms.TestData.main(TestData.java:46)DriverExcepion:com.microsoft.jdbc.sqlserver.SQLServerDriver 你要把三个驱动放动lib目录下去,另外 con = DriverManager.getConnection("jdbc:microsoft:sqlserver:1433;DatabaseName=pubs","sa","23");就可以了。我没看懂你加个//是做什么用的 我从微软的网站上,下载的sqlServer驱动是个可执行文件,不知楼上朋友所谓的三个驱动为何物?再者,要连接的计算机的IP也是需要设置的呀? 那三个jar文件是在安装后的lib文件夹中找到的,将其引入jb中便可以使用,此问题已解决。 Android手机切换皮肤 一元二次方程 j2se 求解决!! JDK升级安装的问题?非常紧急 sun.net.ftp.FtpClient再提问 请问jdk里有没有多线程的检测多个ip地址能否连通的方法? JTable里,如何做到CELL不可编辑 闪烁问题,期待解答,谢谢!! 请问怎么将一个文件的内容以JTree的形式显示? 初学JAVA 怎样编译JAVA文件(做了一个sample.java文件,不知道怎样编译) 请问有谁有JAVA的编码规范 Java的跨平台原理??(细节) 有JFC资料?
package sms;
import java.sql.*;public class TestData
{
Connection con;
Statement st;
ResultSet rs;
public TestData()
{
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con = DriverManager.getConnection("jdbc:microsoft:sqlserver://服务器IP:1433;DatabaseName=服务器SQLServer数据库名","sa","23");
st = con.createStatement();
}
catch (Exception e)
{
System.out.println("DriverExcepion:" + e.getMessage());
}
} public ResultSet executeQuery(String sql)
{
rs = null;
try
{
rs = st.executeQuery(sql);
}
catch (SQLException ex)
{
System.out.println("executeQuery :" + ex.getMessage());
System.out.println("sql=" + sql);
}
return rs;
} public static void main(String args[])
{
String time="";
TestData td = new TestData();
String sql="select recv_time from sms_recv where id=100"; //sms_recv为服务器上的表名
try
{
ResultSet rs2 = td.executeQuery(sql);
while(rs2.next())
{
time=rs2.getString("recv_time");
System.out.println("time ="+time);
}
rs2.close();
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
td = null;
}
}
}异常:
C:\JBuilder9\jdk1.4\bin\javaw -classpath "E:\bovey\prog\lhyd\classes;C:\JBuilder9\thirdparty\jakarta-tomcat-4.0.6-LE-jdk14\common\lib\servlet.jar;C:\JBuilder9\jdk1.4\demo\jfc\Java2D\Java2Demo.jar;C:\JBuilder9\jdk1.4\demo\plugin\jfc\Java2D\Java2Demo.jar;C:\JBuilder9\jdk1.4\jre\lib\charsets.jar;C:\JBuilder9\jdk1.4\jre\lib\ext\dnsns.jar;C:\JBuilder9\jdk1.4\jre\lib\ext\ldapsec.jar;C:\JBuilder9\jdk1.4\jre\lib\ext\localedata.jar;C:\JBuilder9\jdk1.4\jre\lib\ext\sunjce_provider.jar;C:\JBuilder9\jdk1.4\jre\lib\im\indicim.jar;C:\JBuilder9\jdk1.4\jre\lib\jaws.jar;C:\JBuilder9\jdk1.4\jre\lib\jce.jar;C:\JBuilder9\jdk1.4\jre\lib\jsse.jar;C:\JBuilder9\jdk1.4\jre\lib\rt.jar;C:\JBuilder9\jdk1.4\jre\lib\sunrsasign.jar;C:\JBuilder9\jdk1.4\lib\dt.jar;C:\JBuilder9\jdk1.4\lib\htmlconverter.jar;C:\JBuilder9\jdk1.4\lib\tools.jar" sms.TestData
java.lang.NullPointerException at sms.TestData.executeQuery(TestData.java:29) at sms.TestData.main(TestData.java:46)DriverExcepion:com.microsoft.jdbc.sqlserver.SQLServerDriver
con = DriverManager.getConnection("jdbc:microsoft:sqlserver:1433;DatabaseName=pubs","sa","23");就可以了。我没看懂你加个//是做什么用的