Java连接Mysql（JDBC）

最新推荐文章于 2023-07-13 11:33:21 发布

Vicky_Tang

最新推荐文章于 2023-07-13 11:33:21 发布

阅读量1w

点赞数 2

文章标签： java maven jdbc mysql

本文链接：https://blog.csdn.net/sweet19920711/article/details/119789834

版权

一、创建Java Maven工程

导入JDBC依赖：

    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.47</version>
    </dependency>

二、加载驱动

Class.forName("com.msyql.jdbc.Driver");

三、创建连接

Connection conn = DriverManager.getConnetcion("jdbc:mysql://192.168.131.200:3306/test?useSSL=false", "root", "12345678");

四、预编译SQL语句

PreparedStatement ps = conn.prepareStatement("select * from user_info");

五、返回结果集

ResultSet rs = ps.executeQuery();

六、遍历结果集输出

while(rs.next){
    System.out.print(rs.getObject(1));
    System.out.print("\t");
    System.out.print(rs.getObject(2));
    System.out.print("\t");
    System.out.print(rs.getObject(3));
    System.out.print("\t");
    System.out.println(rs.getObject(4));
}

附录：完整代码

package cn.kgc;

import java.sql.*;

public class Jdbc {
    public static void main(String[] args) {
        //为了释放资源，需要提前定义
        Connection conn = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://192.168.131.200:3306/test?useSSL=false", "root", "12345678");
            ps = conn.prepareStatement("select * from user_info");
            rs = ps.executeQuery();
            while (rs.next()){
                System.out.print(rs.getObject(1));
                System.out.print("\t");
                System.out.print(rs.getObject(2));
                System.out.print("\t");
                System.out.print(rs.getObject(3));
                System.out.print("\t");
                System.out.println(rs.getObject(4));
            }
        } catch (Exception e) {
            e.printStackTrace();
        }finally {
            try {
                //释放资源
                rs.close();
                ps.close();
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}