标准的MySQL JDBC程序

我会带着你远行 2022-06-03 04:19 112阅读 0赞

标准的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();
                    }
                }
            
            }
        }
    }