传统的JDBC连接数据库操作

别整那么多废话，直接上代码；

package cn.mike.javase.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class JDBC_Connection {

    public static void main(String[] args) {

        Connection conn = null;// connection

        PreparedStatement preState = null;// prepared statement

        ResultSet resultSet = null;// resultset

        try {
            // load driver
            Class.forName("com.mysql.jdbc.Driver");

            // get connection
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/ibatis_test", "root", "3713");

            /* sql statement */
            String querySql = "SELECT * FROM USERS WHERE USERNAME = ?";

            // prepare statement
            preState = conn.prepareStatement(querySql);

            // set parameter
            preState.setString(1, "michael");

            // execute query
            resultSet = preState.executeQuery();

            // iterate result set
            while (resultSet.next()) {
                System.out.println(resultSet.getString("id") + "\t" + resultSet.getString("username") + "\t" + resultSet.getString("password"));
            }

        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }

        // close streams seperately
        try {
            if (null != resultSet) {
                resultSet.close();
            }
            if (null != preState) {
                preState.close();
            }
            if (null != conn) {
                conn.close();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }

    }

}