安装完,把msutil.jar,mssqlserver.jar、msbase.jar Copy到jdk的lib目录下,然后在程序中Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String databaseURL="jdbc:microsoft:sqlserver://172.16.0.59:1433;DatabaseName=YourDatabase";
Connection conn=DriverManager.getConnection(databaseURL,user,password);
--------------------------------------------------------^^^^^^^^^^^^^连接数据库的用户名和密码
String databaseURL="jdbc:microsoft:sqlserver://172.16.0.59:1433;DatabaseName=YourDatabase";
Connection conn=DriverManager.getConnection(databaseURL,user,password);
--------------------------------------------------------^^^^^^^^^^^^^连接数据库的用户名和密码
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://204.1.16.50:1433", "sa", "123456");
import java.sql.Connection;
import java.sql.Statement;
import java.sql.SQLException;
import java.sql.ResultSet;
/*
本程序为操作sqlserver2000数据库的jdbc程序
jdk1.4下成功
*/
public class sqlserv
{
public static void main(String args[]) throws SQLException,ClassNotFoundException
{
/*
djb为在管理工具-数据源odbc-系统dsn中的数据源名称
*/
String strConnectionURL="jdbc:odbc:djb",
strUserName="djb", strPassWord="djb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn =DriverManager.getConnection (strConnectionURL,strUserName, strPassWord);
Statement stmt = conn.createStatement();
ResultSet rstr = stmt.executeQuery("select * from SYSUSERS");
System.out.println("");
while(rstr.next())
{
SYSUSR_ID = rstr.getString(1);
SYSUSR_NAME = rstr.getString(2);
SYSUSR_PWD = rstr.getString(3);
SYSUSR_PRIVID = rstr.getString(4);
NWEST_IP = rstr.getString(5);
NWEST_TIME = rstr.getString(6);
}
}}