[Java] TestMysqlConnection ( Java 连接 mysql 初步)

来源：互联网发布：iphone看电影软件编辑：程序博客网时间：2024/05/07 23:36
import java.sql.*;public class TestMysqlConnection {    public static void main(String[] args) {        Connection conn = null;        Statement stmt = null;        ResultSet rs = null;        try {            Class.forName("com.mysql.jdbc.Driver");            System.out.println("HERE");            conn = DriverManager.getConnection("jdbc:mysql://localhost/mydata?user=root&password=root");            System.out.println("HERE");            stmt = conn.createStatement();            rs = stmt.executeQuery("select * from dept");            while (rs.next()) {                System.out.println(rs.getString("deptno"));            }        } catch (ClassNotFoundException e) {            e.printStackTrace();        } catch (SQLException ex) {            // handle any errors            System.out.println("SQLException: " + ex.getMessage());            System.out.println("SQLState: " + ex.getSQLState());            System.out.println("VendorError: " + ex.getErrorCode());        } finally {            try {                if (rs != null) {                    rs.close();                    rs = null;                }                if (stmt != null) {                    stmt.close();                    stmt = null;                }                if (conn != null) {                    conn.close();                    conn = null;                }            } catch (SQLException e) {                e.printStackTrace();            }        }    }}
0 0