通過JDBC對MySql進行增/刪/改/查操作

新建BaseDao

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class BaseDao {

    Connection con = null;

    Statement st = null;

    ResultSet rs = null;

/** 
 * 獲得聯接 
 *  
 * @return 
 */  
public Connection getConnection() {  
    try {  
        // 加載驅動，這一句也可寫為：Class.forName("com.mysql.jdbc.Driver");   
        Class.forName("com.mysql.jdbc.Driver").newInstance();  

        // 建立到MySQL的連接   
        con = DriverManager.getConnection("jdbc:mysql://localhost:3306/money_note?characterEncoding=UTF-8", "root", "root");  
    } catch (Exception e) {  
        e.printStackTrace();  
    }  
    return con;  
}  

/** 
 * 關閉數據源 
 */  
public void CloseConnection(Connection con, Statement s, ResultSet rs) {  
    try {  
        if (rs != null) {  
            rs.close();  
        }  
        if (s != null) {  
            s.close();  
        }  
        if (con != null) {  
            con.close();  
        }  
    } catch (SQLException e) {  
        e.printStackTrace();  
    }  
}  

}  </pre> 

 測試類
import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class Test extends BaseDao {

Connection con = null;  
Statement st = null;  
ResultSet rs = null;  

/** 
 * 查詢數據 
 */  
public void find() {  
    con = getConnection();  // 獲得聯接  
    try {  
        st = con.createStatement();  
        rs = st.executeQuery("select * from app_user");  
        while (rs.next()) {  
            System.out.println("編號：" + rs.getInt("uuid") + ", 姓名：" + rs.getString("userName") + ", 性別：" + rs.getString("sex") + ", 生日：" + rs.getString("birthday") + ", 住址：" + rs.getString("address"));  
        }  
    } catch (SQLException e) {  
        e.printStackTrace();  
    } finally {  
        CloseConnection(con, st, rs);   // 關閉聯接  
    }  
}  

/** 
 * 添加數據 
 */  
public void add() {  
    con = getConnection();  
    try {  
        st = con.createStatement();  
        int result = st.executeUpdate("insert into app_user(userName,passWord,sex,birthday,address) values('趙麗穎','wanying','女','1992-02-03','北京市')");  
        if (result > 0) {  
            System.out.println("插入成功");  
        } else {  
            System.out.println("插入失敗");  
        }  
    } catch (SQLException e) {  
        System.out.println("插入失敗");  
        e.printStackTrace();  
    } finally {  
        CloseConnection(con, st, rs);  
    }  
}  

/** 
 * 更新數據 
 */  
public void update() {  
    con = getConnection();  
    try {  
        st = con.createStatement();  
        int result = st.executeUpdate("update app_user set address = '河南' where uuid = '3'");  
        if (result > 0) {  
            System.out.println("更新成功");  
        } else {  
            System.out.println("更新失敗");  
        }  
    } catch (SQLException e) {  
        e.printStackTrace();  
    } finally {  
        CloseConnection(con, st, rs);  
    }  
}  

/** 
 * 刪除數據 
 */  
public void delete() {  
    con = getConnection();  
    try {  
        st = con.createStatement();  
        int result = st.executeUpdate("delete from app_user where uuid = '3'");  
        if (result > 0) {  
            System.out.println("刪除成功");  
        } else {  
            System.out.println("刪除失敗");  
        }  
    } catch (SQLException e) {  
        e.printStackTrace();  
    } finally {  
        CloseConnection(con, st, rs);  
    }  
}  

public static void main(String[] args) {  
    Test test = new Test();  
    //test.add();  
    // test.update();  
     test.delete();  
    test.find();  

}  


}  </pre>