jdbc 串連mysql資料庫

標籤：

jdbc開車到官網下載，上jdk相關的檔案夾或更少。要麼jar添加的檔案project以下

package test_mysql;import java.sql.*;import java.util.Set;public class testjdbc {public static Connection getConnection() throws ClassNotFoundException, SQLException{String URL="jdbc:mysql://localhost:3306/employees";//載入驅動程式Class.forName("com.mysql.jdbc.Driver");String user="root";String passwd="";//預設密碼為空白//還有選擇資料庫，哪個資料//DriverManager.//Connection con=DriverManager.getConnection(URL, user, passwd);//Connection con=DriverManager.getConnection(url, user, password);String test_url="";//String my_url="jdbc:mysql://localhost:3306;DatabaseName=employees;User=root;Password=";//test_url+=URL+3306+";"+"DatabaseName=employees;"+"User=root;"+"Password="+"";Connection con=DriverManager.getConnection(URL,user,passwd);return con;}public static void main(String[] args){String sql="select * from  departments";Statement statement=null;Connection con=null;ResultSet set=null;try {con = getConnection();//con.setif(con==null)System.out.println("con null");statement=con.createStatement();set=statement.executeQuery(sql);//int n=set.getFetchSize();//System.out.println(n);while(set.next()){System.out.println(set.getString(1)+"  "+set.getString(2));}} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally{  if(con!=null)try {set.close();statement.close();con.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}}

著作權聲明：本文部落格原創文章，部落格，未經同意，不得轉載。

jdbc 串連mysql資料庫