用java(myeclipse) 连接mysql数据库,怎么写?

如题所述

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();
        }
    }
}
温馨提示:内容为网友见解,仅供参考
无其他回答
相似回答