小白 求大神解答 eclipse连接mysql语句改成连接sql2008

package library;

import javax.swing.*;
import java.sql.*;

public class Database{

private String url = "jdbc:mysql://localhost/library";//
//private String url = "jdbc:mysql://localhost:3306/library";
public static Connection con;
public Statement stmt, stmt2;
//MySQL数据库账户密码
private String userName = "root";
private String userPasswd = "xia";

public void dbCon(){
       /*try{
    Class.forName("org.gjt.mm.mysql.Driver");
    //Class.forName("com.mysql.jdbc.Driver");
    //Class.forName("org.gjt.mm.mysql.Driver").newInstance();
    }catch(ClassNotFoundException e){
    JOptionPane.showMessageDialog(null,"数据库驱动程序加载失败！","提示！",
    JOptionPane.YES_NO_OPTION);
    }*/
    try{
        con = DriverManager.getConnection(url, userName, userPasswd);
        stmt = con.createStatement();
    }
    catch(Exception g){
        JOptionPane.showMessageDialog(null, "数据库连接失败！", "提示！",
                JOptionPane.YES_NO_OPTION);
        System.out.println("E M: " + g.getMessage());
    }
}

public void dbClose(){
    try{
        con.close();
    }
    catch(SQLException g){
        JOptionPane.showMessageDialog(null, "数据库断开时出错！", "提示！",
                JOptionPane.YES_NO_OPTION);
        System.out.println("E M" + g.getMessage());
    }
}

}

http://jingyan.baidu.com/article/cbf0e500ed68622eab289356.html
sql server依据你sql实例名，连接协议，账户验证方式不同，连接字符串略有不同。

看我给你的链接。这是一个大概，而且还要取决于你的sql server本身的配置
如果你什么都不懂，这个要找本书看看，或者问问同事

private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static final String URL="jdbc:sqlserver://localhost:1433;databaseName=myweb";//这里的dataBaseName 就是 sql中 create database name 中的name
private static final String USER="sa";
private static final String PASSWORD=""; // 密码

你去我的博客看看上午刚写的