首先要下載Connector/J地址:/downloads/connector/j/
這是MySQL官方提供的連接方式:
解壓後得到jar庫文件,需要在工程中導入該庫文件
我是用的是Eclipse:
JAVA連接MySQL稍微繁瑣,所以先寫壹個類用來打開或關閉數據庫:DBHelper.java
Java代碼 ?
package?com.hu.demo;?
import?java.sql.Connection;?
import?java.sql.DriverManager;?
import?java.sql.PreparedStatement;?
import?java.sql.SQLException;?
public?class?DBHelper?{?
public?static?final?String?url?=?"jdbc:mysql://127.0.0.1/student";?
public?static?final?String?name?=?"com.mysql.jdbc.Driver";?
public?static?final?String?user?=?"root";?
public?static?final?String?password?=?"root";?
public?Connection?conn?=?null;?
public?PreparedStatement?pst?=?null;?
public?DBHelper(String?sql)?{?
try?{?
Class.forName(name);//指定連接類型?
conn?=?DriverManager.getConnection(url,?user,?password);//獲取連接?
pst?=?conn.prepareStatement(sql);//準備執行語句?
}?catch?(Exception?e)?{?
e.printStackTrace();?
}?
}?
public?void?close()?{?
try?{?
this.conn.close();?
this.pst.close();?
}?catch?(SQLException?e)?{?
e.printStackTrace();?
}?
}?
}?
再寫壹個Demo.java來執行相關查詢操作
Demo.java
Java代碼 ?
package?com.hu.demo;?
import?java.sql.ResultSet;?
import?java.sql.SQLException;?
public?class?Demo?{?
static?String?sql?=?null;?
static?DBHelper?db1?=?null;?
static?ResultSet?ret?=?null;?
public?static?void?main(String[]?args)?{?
sql?=?"select?*from?stuinfo";//SQL語句?
db1?=?new?DBHelper(sql);//創建DBHelper對象?
try?{?
ret?=?db1.pst.executeQuery();//執行語句,得到結果集?
while?(ret.next())?{?
String?uid?=?ret.getString(1);?
String?ufname?=?ret.getString(2);?
String?ulname?=?ret.getString(3);?
String?udate?=?ret.getString(4);?
System.out.println(uid?+?"\t"?+?ufname?+?"\t"?+?ulname?+?"\t"?+?udate?);?
}//顯示數據?
ret.close();?
db1.close();//關閉連接?
}?catch?(SQLException?e)?{?
e.printStackTrace();?
}?
}?
}?
測試數據庫是在上壹章 中建立的,所以直接查詢: 結果和用C#連接MySQL查詢的結果壹樣