Class.forName(driver);

Connection con = DriverManager.getConnection(url,username,password);

import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class DBConnection{public static void main(String[] args){String driver = "com.mysql.jdbc.Driver";//localhost指本機(jī)，也可以用本地ip地址代替，3306為MySQL數(shù)據(jù)庫的默認(rèn)端口號，“user”為要連接的數(shù)據(jù)庫名String url = "jdbc:mysql://localhost:3306/user";//填入數(shù)據(jù)庫的用戶名跟密碼String username = "test";String password = "test";String sql = "select * from user";//編寫要執(zhí)行的sql語句，此處為從user表中查詢所有用戶的信息try{Class.forName(driver);//加載驅(qū)動程序，此處運(yùn)用隱式注冊驅(qū)動程序的方法}catch(ClassNotFoundException e){e.printStackTrace();}try{Connection con = DriverManager.getConnection(url,username,password);//創(chuàng)建連接對象Statement st = con.createStatement();//創(chuàng)建sql執(zhí)行對象ResultSet rs = st.executeQuery(sql);//執(zhí)行sql語句并返回結(jié)果集while(rs.next())//對結(jié)果集進(jìn)行遍歷輸出{System.out.println("username: "+rs.getString(1));//通過列的標(biāo)號來獲得數(shù)據(jù)System.out.println("useradd: "+rs.getString("useradd"));//通過列名來獲得數(shù)據(jù)System.out.println("userage: "+rs.getInt("userage"));}//關(guān)閉相關(guān)的對象if(rs != null){try{rs.close();}catch(SQLException e){e.printStackTrace();}}if(st != null){try{st.close();}catch(SQLException e){e.printStackTrace();}}if(con !=null){try{con.close();}catch(SQLException e){e.printStackTrace();}}}catch(SQLException e){e.printStackTrace();}}}