jdbc连接mysql

最新推荐文章于 2025-04-16 09:33:49 发布

honty

最新推荐文章于 2025-04-16 09:33:49 发布

阅读量294

点赞数

分类专栏： java新手学习文章标签： jdbc null exception import mysql string

本文链接：https://blog.youkuaiyun.com/honty/article/details/5631597

版权

java新手学习专栏收录该内容

6 篇文章

订阅专栏

1,DriverManager中注册驱动

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

public class LoadDriver {

    public static void main(String[] args) {

        try {

                       Class.forName("com.mysql.jdbc.Driver").newInstance();

        } catch (Exception ex) {

2,从DriverManager获得连接实例

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
 
     try {
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/test?user=honty&password=123456");

                 
} catch (SQLException ex) {
                 
}
3,使用java.sql.Statement执行SELECT查询
Statement stmt = null;
ResultSet rs = null;

try {
    stmt = conn.createStatement();
    rs = stmt.executeQuery("SELECT foo FROM bar");
    if (stmt.execute("SELECT foo FROM bar")) {
        rs = stmt.getResultSet();
    }

    } finally {
  
    if (rs != null) {
        try {
            rs.close();
        } catch (SQLException sqlEx) { }

        rs = null;
    }

    if (stmt != null) {
        try {
            stmt.close();
        } catch (SQLException sqlEx) {}

        stmt = null;
    }
}