java连接数据库

package wx1;

 

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

/**

 *

 * @author April</br>

 * @date 2018-11-28

 *

 */

public class Test {

    public static void main(String[] args) {

        String driver = "com.mysql.cj.jdbc.Driver";

       // String dbName = "weixin";

        String passwrod = "april";

        String userName = "root";

        String url="jdbc:mysql://localhost:3306/weixin?useUnicode=true&allowPublicKeyRetrieval=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false";

        String sql = "select * from userinfo";

 

        try {

            Class.forName(driver);

            Connection conn = DriverManager.getConnection(url, userName,

                    passwrod);

            PreparedStatement ps = conn.prepareStatement(sql);

            ResultSet rs = ps.executeQuery();

            while (rs.next()) {

                System.out.println("id : " + rs.getInt(1) + " name : "

                        + rs.getString(2) + " avatar : " + rs.getString(3));

            }

 

            // 关闭记录集

            if (rs != null) {

                try {

                    rs.close();

                } catch (SQLException e) {

                    e.printStackTrace();

                }

            }

 

            // 关闭声明

            if (ps != null) {

                try {

                    ps.close();

                } catch (SQLException e) {

                    e.printStackTrace();

                }

            }

 

            // 关闭链接对象

            if (conn != null) {

                try {

                    conn.close();

                } catch (SQLException e) {

                    e.printStackTrace();

                }

            }

 

        } catch (Exception e) {

            e.printStackTrace();

        }

    }

 

}