步骤A图.

来源：互联网发布：遗传bp算法计算器编辑：程序博客网时间：2024/06/08 17:28

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,'user1',2111,'admin');
insert into msw values( 3,'user1',3111,'admin');

好运，祝您接続成功。

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

Connection Successful!
1    user1    1111    1111    1

2    manager1    2222    2222    2

3    user3    3333    3333    3