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

Question

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());
    }
}

}

Answer 1

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