Java语句轻松实现与数据库MYSQL【本地数据库】的连接，和对数据库的增删改查操作

工作内容：

使用java连接MYSQL数据库

学习分享：

1.先导入一个mysql-connector-java-5.1.30-bin.jar包(需网上下载)

2.在Eclipse中，选择菜单“项目”->属性->Java构建路径，在“库”选项卡中，选择“添加外部JAR”，找到下载的mysql-connector-java-5.1.30-bin.jar文件，将其添加进项目。

3.本地下载并安装好MYSQL，新建数据库：myrobot_db，账号：root，密码：zhangsan 【账号，密码都是自定义的】

具体代码如下：

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

public class MySqlUtil {
    private static List<AccountInfo> list;
    public static void main(String arg[]) {
        list = new ArrayList<>();
        try {
            Connection con = null; //定义一个MYSQL链接对象
            Class.forName("com.mysql.jdbc.Driver").newInstance(); //MYSQL驱动
            //链接本地MYSQL【3306端口号，myrobot_db数据库名称，root数据库连接账户名，zhangsan密码】
            con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/myrobot_db", "root", "zhangsan");
            System.out.println("connect success");
            Statement stmt; //创建声明
            stmt = con.createStatement();

            //新增一条数据
            stmt.executeUpdate("INSERT INTO account_tb (account, password,telephonenumber"
                    + ",mail,qq,id) VALUES ('liu', '123456','13541524365','ying@163.com','64545636','8')");
            System.out.println("insert success");

            //删除一条数据
            String sql = "DELETE FROM account_tb WHERE id = 5";
            long deleteRes = stmt.executeUpdate(sql); //如果为0则没有进行删除操作，如果大于0，则记录删除的条数
            System.out.println("DELETE:" + deleteRes);

            //更新一条数据
            String updateSql = "UPDATE account_tb SET account = 'zhangsanfeng' WHERE id = 2";
            long updateRes = stmt.executeUpdate(updateSql);
            System.out.print("UPDATE:" + updateRes);

            //查询数据并输出
            String selectSql = "SELECT * FROM account_tb";
            ResultSet selectRes = stmt.executeQuery(selectSql);
            while (selectRes.next()) { //循环输出结果集
                String account = selectRes.getString("account");
                String telephonenumber = selectRes.getString("telephonenumber");
                String mail = selectRes.getString("mail");
                String qq = selectRes.getString("QQ");
                int id = selectRes.getInt("id");
                list.add(new AccountInfo(account, telephonenumber, mail, qq, id));
            }
            System.out.println("得到的list的长度是："+list.size());
            for (int i = 0; i < list.size(); i++) {
                System.out.println(list.get(i));
            }
            System.out.println(list.get(0));
        } catch (Exception e) {
            System.out.print("MYSQL ERROR:" + e.getMessage());
        }
    }
}

涉及类：【用于将搜索到的数据生成对象】

public class AccountInfo {
    private String account,telephonenumber,mail,qq;
    private int id;
    public AccountInfo(String account, String telephonenumber, String mail, String qq, int id) {
        super();
        this.account = account;
        this.telephonenumber = telephonenumber;
        this.mail = mail;
        this.qq = qq;
        this.id = id;
    }
    @Override
    public String toString() {
        return "AccountInfo [account=" + account + ", telephonenumber=" + telephonenumber + ", mail=" + mail + ", qq="
                + qq + ", id=" + id + "]";
    }
    public String getAccount() {
        return account;
    }
    public void setAccount(String account) {
        this.account = account;
    }
    public String getTelephonenumber() {
        return telephonenumber;
    }
    public void setTelephonenumber(String telephonenumber) {
        this.telephonenumber = telephonenumber;
    }
    public String getMail() {
        return mail;
    }
    public void setMail(String mail) {
        this.mail = mail;
    }
    public String getQq() {
        return qq;
    }
    public void setQq(String qq) {
        this.qq = qq;
    }
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
}