java连接mysql数据库操作

一、java连接mysql数据库操作

    <dependencies>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.38</version>
        </dependency>
    </dependencies>

package Day.JDBC1;
import java.sql.*;
public class test1 {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        //1.注册数据库
        Class.forName("com.mysql.jdbc.Driver");
        //2.获取连接
        String url="jdbc:mysql://127.0.0.1:3306/school";
        String user="root";
        String password="123456";
        Connection con=DriverManager.getConnection(url,user,password);
        //3.获取传输器
        Statement stat=con.createStatement();
        //4.执行sql语句获取结果集
        String sql="select * from student";
        ResultSet rs=stat.executeQuery(sql);
        //5.具体处理
        while(rs.next()){
            String a=rs.getString(2);
            System.out.println(a);
        }
        //6关闭资源
        rs.close();
        stat.close();
        con.close();
    }

}