非常不解 我用jdbc-odbc的形式连接就可以
使用jdbc就不行了，程序如下：
package com.ch1;
import java.sql.*;
public class Test {
PreparedStatement ps=null;
Connection ct=null;
ResultSet rs=null;
public static void main(String[] args){
Test test=new Test();
}
public Test(){
try {
//1.加载驱动
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//2.得到连接
ct=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatebaseName=Company","sa","lichangya520");
//3.创建PreparedStatement
ps=ct.prepareStatement("select *from dept");
rs=ps.executeQuery();
while(rs.next())
{
int no=rs.getInt(1);
String name=rs.getString(2);
String local=rs.getString(3);
System.out.println(no+" "+name+" "+local);
}
}catch(Exception e){
e.printStackTrace();
}finally{
try{
if(rs!=null)
{
rs.close();
}
if(ps!=null)
{
ps.close();
}
if(ct!=null)
{
ct.close();
}
}catch(Exception e){
e.printStackTrace();
}
}
}
}执行后的结果：
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]对象名 'dept' 无效。
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)
at com.ch1.Test.<init>(Test.java:21)
at com.ch1.Test.main(Test.java:10)
本人纠结了好久，希望各位大神帮忙解决，谢谢！
------解决思路----------------------
jdbc:sqlserver://localhost:1433;DatebaseName=Company
你自己看看这里面哪里错了吧？ 看样子英文不太好啊。data / date ?
------解决思路----------------------
楼上正解。这东西都是复制粘贴，你自己手打反而会惹来不必要的麻烦。。反正我现在实习很多都是COPY改。。