标准的MySQL JDBC程序

标准的MySQL JDBC操作代码，驱动到官网下载，解压出.jar的文件mysql-connector-java-5.1.45-bin.jar。

https://dev.mysql.com/downloads/connector/j/

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

public class TestMySQLJDBC {
    static final String driver_class  = "com.mysql.jdbc.Driver";
    static final String connectionURL = "jdbc:mysql://10.10.18.141:3306/test";
    static final String userID        = "root";
    static final String userPassword  = "";
    public static void main(String[] args) throws Exception {
        Connection conn = null;
        String sql = null;
        PreparedStatement preStmt =null;
        ResultSet rs = null;
        try {
            Class.forName(driver_class);
            conn = DriverManager.getConnection(connectionURL,userID,userPassword);
            sql = "select * from tt where id = ? and name = ? ";
            preStmt = conn.prepareStatement(sql);
            preStmt.setInt(1, 1);
            preStmt.setString(2, "a");
            System.out.println("绑定变量后的sql:"+preStmt.toString());
            rs = preStmt.executeQuery();
            while(rs.next()){
            	System.out.println("id:"+rs.getInt("id")+"  name:"+rs.getString("name"));
            }
        } catch(SQLException e) {
            System.out.println("MySQL操作错误");
            e.printStackTrace();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {

            if(preStmt != null){
                try {
                	preStmt.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            if(conn != null){
                try {
                	conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        
        }
    }
}