mysql jdbc 连接

最新推荐文章于 2024-04-09 23:17:20 发布

chen_jiangtao

最新推荐文章于 2024-04-09 23:17:20 发布

阅读量552

点赞数

文章标签： jdbc mysql null string url class

本文链接：https://blog.csdn.net/evane1890/article/details/2801349

版权

package com.cjt.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class MysqlTest {

    /**
    * @param args
    * @throws ClassNotFoundException
    * @throws SQLException
    */
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        // TODO Auto-generated method stub

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

        //org.gjt.mm.mysql.Driver

        Connection conn = null;

        Statement stmt = null;

        ResultSet rs =null;
        String url = "jdbc:mysql://localhost:3306/mysql";
        conn = DriverManager.getConnection(url,"root","");
        stmt = conn.createStatement();

        rs = stmt.executeQuery("select * from user");

        while(rs.next())
        {
            System.out.println(rs.getObject(1));
        }

        stmt.close();

        conn.close();

    }

}