JDBC连接Mysql

JDBC连接Mysql
1.导入驱动jar包
*复制mysql-connector-java-5.1.17.jar到项目的libs目录下
*右键—>Add As Library

2.注册驱动

//2.注册驱动
Class.forName("com.mysql.jdbc.Driver");

3.获取数据库连接对象 Connection

 //3.获取数据库连接对象
Connection conn = DriverManager.getConnection("jdbc:mysql://master:3306/shujia", "root", "123456");

4.定义sql

 //4.定义sql语句
String sql = "select * from account";

5.获取执行sql语句的对象 Statement

//5.获取执行sql的对象
Statement statement = conn.createStatement();

6.执行sql,接受返回结果

//6.执行sql
ResultSet resultSet = statement.executeQuery(sql);

7.处理结果

//7.结果处理
// System.out.println(i);
while (resultSet.next()){
      String string = resultSet.getString(2);
      System.out.println(string);
}

8.释放资源

//8.释放资源
resultSet.close();
statement.close();
conn.close();

整合

/**
 * JDBC快速入门
 */
public class JdbcDemo01 {
    public static void main(String[] args) throws Exception {
        //1.导入jar包
        //2.注册驱动
        Class.forName("com.mysql.jdbc.Driver");
        //3.获取数据库连接对象
        Connection conn = DriverManager.getConnection("jdbc:mysql://master:3306/shujia", "root", "123456");
        //4.定义sql语句
        String sql = "select * from account";
//        String sql = "UPDATE account set balance = balance + 1000 where id = 1";
//        String sql = "UPDATE account set balance = 1000";
        //5.获取执行sql的对象
        Statement statement = conn.createStatement();
        //6.执行sql
        ResultSet resultSet = statement.executeQuery(sql);
//        int i = statement.executeUpdate(sql);
        //7.结果处理
//        System.out.println(i);
        while (resultSet.next()){
            String string = resultSet.getString(2);
            System.out.println(string);
        }
        //8.释放资源
        resultSet.close();
        statement.close();
        conn.close();


    }

}