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)端口號(hào)，“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ū)動(dòng)程序，此處運(yùn)用隱式注冊(cè)驅(qū)動(dòng)程序的方法
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
try
{
Connection con = DriverManager.getConnection(url,username,password);//創(chuàng)建連接對(duì)象
Statement st = con.createStatement();//創(chuàng)建sql執(zhí)行對(duì)象
ResultSet rs = st.executeQuery(sql);//執(zhí)行sql語句并返回結(jié)果集
while(rs.next())//對(duì)結(jié)果集進(jìn)行遍歷輸出
{
System.out.println("username: "+rs.getString(1));//通過列的標(biāo)號(hào)來獲得數(shù)據(jù)
System.out.println("useradd: "+rs.getString("useradd"));//通過列名來獲得數(shù)據(jù)
System.out.println("userage: "+rs.getInt("userage"));
}
//關(guān)閉相關(guān)的對(duì)象
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();
}
}
}