【JAVA基础】JAVA连接MYSQL，

【JAVA基础】JAVA连接MYSQL，

首先POM中引入驱动包

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.42</version>
        </dependency>

JAVA代码

public class ConnectionManager {
    private static String driverClass;
    private static String user;
    private static String pwd;
    private static String url;
    private static Connection con;
    static{
        driverClass = "com.mysql.jdbc.Driver";
        url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=gbk";
        user = "root";
        pwd = "1234";
    }
    public static Connection getConnection(){
        try {
            Class.forName(driverClass);
            con = DriverManager.getConnection(url,user,pwd);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return con;
    }

    public static void main(String[] args) {
        Connection con = ConnectionManager.getConnection();
        Statement st;
        try {
            st = con.createStatement();
            String sql = "SELECT s.name,date_format(s.`time`,'%Y-%m-%d %k:%i:%s') time,s.age FROM `student` s where id = 2 ";
            ResultSet rs = st.executeQuery(sql);
            while (rs.next()){
                System.out.println(rs.getString(1));
                System.out.println(rs.getString(2));
                System.out.println(rs.getTimestamp(2));
            }

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