sql sever 连接 mysql_如何将mysql数据库连接方式改为sqlsever

packagecom.scholarship.util;importjava.sql.*;publicclassDB{privatestaticConnectionconn;privatestaticPreparedStatementpstm;privatestaticStatementstmt;privatestaticResultSe...

package com.scholarship.util;

import java.sql.*;

public class DB {

private static Connection conn;

private static PreparedStatement pstm;

private static Statement stmt;

private static ResultSet rs;

//private static String driver = "org.gjt.mm.mysql.Driver";

//private static String url = "jdbc:mysql://127.0.0.1/scholarship";

// private static String user = "";

// private static String pw = "";

private static String driver = "sun.jdbc.odbc.JdbcOdbcDriver";

private static String url = "jdbc:odbc:school";

static{

try{

Class.forName(driver);

}

catch(ClassNotFoundException ex){

System.out.println("加载启动器失败");

ex.printStackTrace();

}

}

public static Connection getConn(){

Connection conn = null;

try{

conn=DriverManager.getConnection(url);

}

catch(SQLException ex){

System.out.println("数据库链接失败");

ex.printStackTrace();

}

return conn;

}

}

展开