mysql

一、安装mysql
mysql下载网址
注意事项：下载社区版commumunity的msi文件，双击该文件安装即可
                  选对话框选择custom，
                  并且后面之添加server的所有文件，其它按照标准格式下载

将数据库连接到navicat注意事项：
                  2059错误
                  1045错误
                 1045错误选择方法3，改密码的sql语句换一下不会报语法错误的sql语句

二、示范JDBC编程
1、数据库驱动
      ClassNotFoundException解决

package Capter13_mysql数据库与JDBC编程;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class ConnMysql {

    public static void main(String[] args) throws SQLException, ClassNotFoundException{

        String driverName = "com.mysql.jdbc.Driver";//com.mysql.cj.jdbc.Driver
        String url = "jdbc:mysql://127.0.0.1:3306/mytest";//localhost:3306
        String user = "root";
        String password = "guozi";

        Class.forName(driverName);//加载驱动
        Connection conn = DriverManager.getConnection(url, user, password);//建立与数据库的连接
        Statement stmt = conn.createStatement();//创建Statement对象

        String sql = " select * from t_extr_dict where property = \"产品总体评价\" and feature_type = \"正面\"";// 
        ResultSet rs = stmt.executeQuery(sql);

        while(rs.next()){
            System.out.println(rs.getInt("id")+"\t"+rs.getString("domain")+"\t"
                              +rs.getString("feature")+"\t"+rs.getString("feature_type"));