jdbc的五种方式

jdbc

相关接口在jdk.api的java.sql里，java.sql扩展包里也有部分接口
配置java-connect-mysql.jar

import com.mysql.jdbc.Driver;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

public class Jdbc {
    public static void main(String[] args) throws SQLException {
    //注册驱动
        Driver driver = new Driver();
        //获得链接
        String url = "jdbc:mysql://localhost:3306/hsp_db";
        jdbc:mysql://ip:端口号/数据库名
        Properties properties = new Properties();
        properties.setProperty("user","root");
        properties.setProperty("password","111");
        Connection connect = driver.connect(url, properties);
        //执行命令
        String sql="insert into actor values(null,'刘德华','男', '1970-11-10','101')";
        Statement statement = connect.createStatement();
        int rows=statement.executeUpdate(sql);
        System.out.println(rows > 0 ? "成功":"失败");
        //关闭资源
        statement.close();
        connect.close();
    }

}

反射加载diver

3

4

5.1.37会自动注册驱动到DiverManager里
class,forname都不用写

5反射加DriverManage

executequery

 Connection connection = DriverManager.getConnection(url, user, password);
        String sql="select * from actor ";
        Statement statement = connection.createStatement();
        ResultSet resultSet = statement.executeQuery(sql);
        while (resultSet.next()){
            int id=resultSet.getInt(1);
            String name=resultSet.getString(2);
            String sex=resultSet.getString(3);
            Date date=resultSet.getDate(4);
            String phone =resultSet.getString(5);
            System.out.println(name+"\t"+sex+"\t"+date+"\t"+phone);

        }