《Mysql應用Java連接MySql的詳細介紹》要點：
本文介紹了Mysql應用Java連接MySql的詳細介紹，希望對您有用。如果有疑問，可以聯系我們。
MYSQL學習 1.
MYSQL學習 現在工程(不是Src)上右鍵--Build Path--Add External Archives,選擇驅動下的那個jar包,這是release版本,bin目錄下的是debug版本.
MYSQL學習 示例在docs下的connector-j.html,里面有例子(其中的test是數據庫名,換位本身的).
代碼如下:
import java.sql.Connection;
?import java.sql.DriverManager;
?import java.sql.SQLException;
?Connection conn = null;
?...
?try {
???? conn =
??????? DriverManager.getConnection("jdbc:mysql://localhost/test?" +
??????????????????????????????????? "user=monty&password=greatsqldb");
???? // Do something with the Connection
??? ...
?} catch (SQLException ex) {
???? // handle any errors
???? System.out.println("SQLException: " + ex.getMessage());
???? System.out.println("SQLState: " + ex.getSQLState());
???? System.out.println("VendorError: " + ex.getErrorCode());
?}
? 2.可以直接在MySql控制臺下創建數據庫,也可以在通過執行 "\. 絕對路徑名".
MYSQL學習 “--”是注釋符.
代碼如下:
View Code
?import java.sql.Connection;
?import java.sql.DriverManager;
?import java.sql.ResultSet;
?import java.sql.SQLException;
?import java.sql.Statement;
?public class mysql {
???? /**
????? * @param args
????? */
???? public static void main(String[] args) {// 多個try合并到一塊,然后使用source --- format
???????? // TODO Auto-generated method stub
???????? //若是用到finally則必要把聲明放在try外邊
???????? Connection conn = null;
???????? Statement stmt = null;
???????? ResultSet rs = null;
???????? try {
???????????? Class.forName("com.mysql.jdbc.Driver");// 后面若是加上".newInstance"則還必要加上幾個拋出異常
???????????? conn = DriverManager.getConnection("jdbc:mysql://localhost/mydata?"
???????????????????? + "user=root&password=root");
???????????? /*
????????????? * java.sql.Statement; 不是com.mysql這個包； 二者不可以同時存在
????????????? */
???????????? stmt = conn.createStatement();
???????????? rs = stmt.executeQuery("select * from info");
???????????? while (rs.next()) {
???????????????? System.out.println(rs.getString("name"));
???????????? }
???????????? // Do something with the Connection
???????? } catch (ClassNotFoundException ex) {
???????????? // handle any errors
???????????? ex.printStackTrace();
???????? } catch (SQLException ex) {
???????????? // TODO Auto-generated catch block
???????????? System.out.println("SQLException: " + ex.getMessage());
???????????? System.out.println("SQLState: " + ex.getSQLState());
???????????? System.out.println("VendorError: " + ex.getErrorCode());
???????? } finally {
???????????? try {
???????????????? if(null!= rs) {
???????????????????? rs.close();
???????????????????? rs = null;
???????????????? }
???????????????? if(null!= stmt) {
???????????????????? stmt.close();
???????????????????? stmt = null;
???????????????? }
???????????????? if(null!= conn) {
???????????????????? conn.close();
???????????????????? conn = null;
???????????????? }
???????????? } catch(SQLException e) {
???????????????? e.printStackTrace();
???????????? }
???????? }
???? }
?}
《Mysql應用Java連接MySql的詳細介紹》是否對您有啟發，歡迎查看更多與《Mysql應用Java連接MySql的詳細介紹》相關教程，學精學透。維易PHP學院為您提供精彩教程。
轉載請注明本頁網址：
http://www.snjht.com/jiaocheng/9841.html
