Question

java怎么提示我找不到getConnection方法？class forName（com.mysql.jdbc.Driver）;加载的驱动类里没有？

package dbtest;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBconnector {

public static Connection getMySQLConnection(String dricerClassName,String serverHost,
String serverPort,String dbName,String userName,String password)throws
ClassNotFoundException,
SQLException{

if(dricerClassName==null){
dricerClassName="com.mysql.jdbc.Driver";
}
if(serverHost==null){serverHost="127.0.0.1";
}

if(serverPort==null){serverPort="3306";
}
String dbURL="jdbc:mysql://"+serverHost+":" +serverPort+"/"+dbName;
Class.forName("com.mysql.jdbc.Driver");

return getConnection(dricerClassName,dbURL,userName,password);
}
public static void main (String[] srgs)throws ClassNotFoundException,
SQLException{

String mySQLDriver="com.mysql.jdbc.Driver";
String dbName="testdb";
String userName="root";
String password="root";
Connection con=DBconnector.getMySQLConnection(mySQLDriver, null, null, dbName,
userName, password);
System.out.println("连接成功");
con.close();
String url="jdbc:mysql://127.0.01.:3306/"+dbName;
con =DBconnector.getConnection(mySQLDriver,url,userName,password);
con.close();
System.out.println("关闭");
}
}

Answer 1

public class DataDao {
private static String url = "jdbc:sqlserver://localhost:1433;DatabaseName=SWGL";
private static String uName = "sa";
private static String passwd = "123456";
private static String driver ="com.microsoft.sqlserver.jdbc.SQLServerDriver";
static{
try {
Class.forName(driver);//加载驱动
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static Connection getConnection(){//获取连接
try {
return DriverManager.getConnection(url, uName, passwd);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
}
public static void closeConn(Connection conn, Statement st, ResultSet rs){//关闭连接
if(rs!=null){
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(st!=null){
try {
st.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
public static void main(String[] args) {
System.out.println(DataDao.getConnection());//测试连接
}
}

Answer 2

getConnection是DriverManager里面的函数，所以在使用getConnection时应该这样定义：DriverManager.getConnection();

Answer 3

getConnection是DriverManager的方法：

return DriverManager.getConnection(dricerClassName,dbURL,userName,password);

Answer 4

getConnection()要用DriverManager来调用

Answer 5

getConnection是DriverManager的方法