標籤：
1.註冊驅動
Class.forname("com.mysql.jdbc.Driver");//這是串連mysql資料庫的驅動
2.擷取資料庫連接
java.sql.Connection conn=java.sql.DriverManager.getConnection(); 3.擷取運算式
java.sql.Statement stmt=conn.createStatement("jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=GBK","root","null");//三個參數分別是資料庫連接的URL,使用者名稱，密碼 4.執行SQL
java.sql.ResultSet rs=stmt.executeQuery("select * from user"); 5.顯示結果集裡面的資料
while(rs.next()){
System.out.println(rs.getInt(1));
System.out.println(rs.getString("username"));
System.out.println(rs.getString("password"));
System.out.pringln();
}//執行插入語句
//stmt.executeUpdate("insert into user values(1,‘中文‘,‘345‘)");
6.釋放資源
rs.close();
stmt.close();
conn.close(); package com.jikexueyuan.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class JDBCTest {
public static void main(String[] args) {
String sql="select * from tbl_user";
Connection conn=null;
Statement st=null;
ResultSet rs=null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/jsp_db","root","");
st=conn.createStatement();
rs=st.executeQuery(sql);
while(rs.next()){
System.out.print(rs.getInt("id")+" ");
System.out.print(rs.getString("name")+" ");
System.out.print(rs.getString("password")+" ");
System.out.print(rs.getString("email")+" ");
System.out.println();
}
} catch (Exception e) {
e.printStackTrace();
}finally {
try {
rs.close();
st.close();
conn.close();
} catch (Exception e2) {
e2.printStackTrace();
}
}
}
}
Java JDBC連結資料庫
