JDBC连接数据库

来源：互联网发布：ubuntu kylin 双显卡编辑：程序博客网时间：2024/06/06 07:07

通过JDBC连接数据库

import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;public class ConnMySQL{    public static void main(String[] args)        throws ClassNotFoundException, SQLException    {        //通过反射加载驱动        String className = "com.mysql.jdbc.Driver";        Class.forName(className);        //获取Connection数据库连接对象        String url = "jdbc:mysql://127.0.0.1:3306/arvin";        Connection connection = DriverManager.getConnection(url, "root", "111111");        //获取Statement对象：执行SQL语句的工具接口        String sql = "select * from ljb_t_student";        java.sql.PreparedStatement pStatement = connection.prepareStatement(sql);        //获取结果集对象resultSet        ResultSet resultSet = pStatement.executeQuery();        while (resultSet.next())        {            System.out.println(resultSet.getInt(1) + "->" + resultSet.getString(2) + ":" + resultSet.getString(3));        }    }}

阅读全文

0 0