Question

用java（myeclipse） 连接mysql数据库，怎么写？

Answer 1

public class DBUtil {
    public static Connection getConnection(){
        Connection conn = null;
        String url = "jdbc:mysql://localhost:3306/stock?"
                + "user=root&password=123456&useUnicode=true&characterEncoding=UTF8";
            //stock是数据库名，root是数据库登陆名，123456是登陆密码
            try {
                Class.forName("com.mysql.jdbc.Driver");
                 conn = DriverManager.getConnection(url);
            } catch (ClassNotFoundException e) {
                // TODO 自动生成的 catch 块
                e.printStackTrace();
            } catch (SQLException e) {
                // TODO 自动生成的 catch 块
                e.printStackTrace();
            }
           return conn;
    }
    public static void close(Connection conn){
        try {
            conn.close();
        } catch (SQLException e) {
            // TODO 自动生成的 catch 块
            e.printStackTrace();
        }
    }
}