步骤A图.

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]用? '(null)' 登?失?。原因: 未与信任 SQL Server ?接相??。

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]用? 'sa' 登?失?。

?

enating scoke..........

ーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーー

步骤A图.

http://p.blog.csdn.net/images/p_blog_csdn_net/masuwen/EntryImages/20090405/1.JPG

?

步骤B图.

?

?

http://p.blog.csdn.net/images/p_blog_csdn_net/masuwen/EntryImages/20090405/2.JPG

?

步骤C图.

http://p.blog.csdn.net/images/p_blog_csdn_net/masuwen/EntryImages/20090405/3.JPG

?

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
/**
?*
?* @author Administrator
?* @version 2009-4-5
?* @deprecated
?*/
public class JdbcTest {
??? public static void main(String[] args) {
??? ??? try {
??? ??? ??? String url = "jdbc:microsoft:sqlserver://localhost:1433;databasename=aicdata";
??? ??? ??? // mydb为数据库
??? ??? ??? String user ="sa";
??? ??? ??? String password ="";
??? ??? ??? Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver")
??? ??? ??? ??? ??? .newInstance();
??? ??? ???
??? ??? ??? Connection conn = DriverManager.getConnection(url,user,password);
??? ??? ??? System.out.println("Connection Successful!");
??? ??? ??? Statement stmt = conn.createStatement();
??? ??? ??? ResultSet? rstt = stmt.executeQuery("select *from users");
??? ??? ??? while( rstt.next()){
??? ??? ??? ??? System.out.print( rstt.getInt("U_ID")+"/t");
??? ??? ??? ??? System.out.print( rstt.getString("U_NAME")+"/t");
??? ??? ??? ??? System.out.print( rstt.getString("U_PASSWORD")+"/t");
??? ??? ??? ??? System.out.print( rstt.getString("U_PASSWORD")+"/t");
??? ??? ??? ??? System.out.print( rstt.getString("U_ROLE")+"/t");
??? ??? ??? ??? System.out.println("/n");
??? ??? ??? ???
??? ??? ??? }
??? ??? } catch (Exception e) {

??? ??? ??? e.printStackTrace();
??? ??? }

??? }
}//end? jdbcTest

?

数据库

?? 数据库名; aicdata

? 数据库表名; users

create table users(

?

? ?? U_ID int? NOT NULL,
? ?? U_NAME varchar? (30)? NOT NULL,
?? ? U_PASSWORD varchar (30)? NOT NULL,
? ?? U_ROLE varchar (30)

)

?

insert into msw values( 1,'user1',1111,'admin');
insert into msw values(2,2111,'admin');
insert into msw values( 3,3111,'admin');

?

好运，祝您接続成功。

?

out.......................

Connection Successful! 1??? user1??? 1111??? 1111??? 1??? 2??? manager1??? 2222??? 2222??? 2??? 3??? user3??? 3333??? 3333??? 3

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!