java代码连接mysql的两种方式

方式1

package com.shujia.mysql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class MsyqlTest2 {
    public static void main(String[] args) throws Exception {
        //1.反射记载Driver
        Class.forName("com.mysql.jdbc.Driver");
        //2.创建连接
        Connection conn = DriverManager.getConnection("jdbc:mysql://master:3306/shujia", "root", "123456");
        //3.1创建执行器  首先加载sql的格式
            // 使用PreparedStatement执行器执行sql时，参数通过？进行传递
        String sql ="select * from student where id = ?";
        PreparedStatement ps = conn.prepareStatement(sql);
        //通过ps。set数据类型(index,value)进行赋值
        ps.setString(1,"1056");
        //3.2通过执行器执行sql获取结果集
        ResultSet rs = ps.executeQuery();//执行sql语句 回去结果集
        //4.解析结果集
        while (rs.next()){
            int id = rs.getInt("id");
            String name = rs.getString("name");
            int age = rs.getInt("age");
            String sex = rs.getString("sex");
            System.out.println(id+"-"+name+"-"+age+"-"+sex);
        }
        rs.close();
        ps.close();
        conn.close();
    }
}

方式2

package com.shujia.mysql;

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

//创建Statement步骤
public class MysqlTest {
    public static void main(String[] args)throws Exception {
        //1.反射加载Driver
        Class.forName("com.mysql.jdbc.Driver");
        //2.创建连接
        Connection conn = DriverManager.getConnection("jdbc:mysql://master:3306/shujia", "root", "123456");
        //3.1创建执行器
        Statement statement = conn.createStatement();
        //3.2执行器执行sql语句 获得ResultSet结果集
        String sql="select * from student";
        ResultSet rs = statement.executeQuery(sql);
        //4.解析结果
        while(rs.next()){
            int id = rs.getInt("id");
            String name = rs.getString("name");
            int age = rs.getInt("age");
            String sex = rs.getString("sex");
            System.out.println(id+"-"+name+"-"+age+"-"+sex);
        }
        rs.close();
        statement.close();
        conn.close();
    }
}