当前位置: 代码迷 >> Java Web开发 >> 小弟正在做java开发,连接数据库时这段程序报错,不知道如何解决,求高人指点,十分感谢
  详细解决方案

小弟正在做java开发,连接数据库时这段程序报错,不知道如何解决,求高人指点,十分感谢

热度:2813   发布时间:2013-02-25 21:22:45.0
小弟正在做java开发,连接数据库时这段程序报错,不知道怎么解决,求高人指点,十分感谢
小弟正在做java开发,连接数据库时这段程序报错,不知道怎么解决,求高人指点,十分感谢
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

//连接数据库实例
public class Base {
public static void main(String args[]) throws SQLException{
template();
}
static void template() throws SQLException{
String url = "jdbc:sqlserver://localhost;integratedSecurity=true;DatabaseName=日报管理系统"; 
String user = "root";
String password = "root";
java.sql.Connection conn = null;
Statement st = null;
ResultSet rs = null;
try{  
//加载MySql的驱动类  
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
System.out.println("驱动注册成功!");
conn = DriverManager.getConnection(url, user, password);
st = conn.createStatement();
rs = st.executeQuery("select *from 角色管理");
while(rs.next()){
System.out.println(rs.getObject(1)+"\t"+rs.getObject(2)+"\t"+rs.getObject(1)+"\t");
}
}catch(ClassNotFoundException e){  
System.out.println("找不到驱动程序类 ,加载驱动失败!");  
e.printStackTrace() ;  

finally{
// 关闭记录集  
try{ 
if(rs != null)  
rs.close() ;  
}finally{  
try{ 
if(st != null)
st.close() ;  
}finally{
if(conn != null){ // 关闭连接对象  
try{  
conn.close();
}catch(SQLException e){  
e.printStackTrace() ;  

}  
}  
}
}
}
}




Exception in thread "main" java.lang.UnsatisfiedLinkError: com.microsoft.sqlserver.jdbc.AuthenticationJNI.GetDNSName(Ljava/lang/String;[Ljava/lang/String;Ljava/util/logging/Logger;)I
at com.microsoft.sqlserver.jdbc.AuthenticationJNI.GetDNSName(Native Method)
at com.microsoft.sqlserver.jdbc.AuthenticationJNI.GetDNSName(AuthenticationJNI.java:109)
at com.microsoft.sqlserver.jdbc.AuthenticationJNI.<init>(AuthenticationJNI.java:63)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2229)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at Base.template(Base.java:22)
at Base.main(Base.java:9)


------解决方案--------------------------------------------------------
探讨
String url = "jdbc:sqlserver://localhost;integratedSecurity=true;DatabaseName=日报管理系统";

------解决方案--------------------------------------------------------
  相关解决方案