JAVA使用JDBC执行select操作数据库的内容-----JAVA

旧约Alatus

已于 2023-11-10 23:07:16 修改

阅读量368

点赞数 1

分类专栏： JAVA 文章标签：数据库 java sql maven mybatis tomcat java-ee

于 2023-05-25 19:15:24 首次发布

本文链接：https://blog.csdn.net/2201_75960169/article/details/130873544

版权

JAVA 专栏收录该内容

534 篇文章 3 订阅

订阅专栏

import java.sql.*;

public class Select
{
    public static void main(String[] args)
    {
        Connection connection = null;
        Statement statement = null;
        try
        {
            Driver driver = new com.mysql.jdbc.Driver();
            DriverManager.registerDriver(driver);
            String url = "jdbc:mysql://127.0.0.1:13306/ip";
            String user = "root";
            String password = "abc123";
            connection = DriverManager.getConnection(url,user,password);
            System.out.println(connection);
            statement = connection.createStatement();
            String sql = "SELECT * FROM countries";
            ResultSet resultSet = statement.executeQuery(sql);
            while(resultSet.next())
            {
                String country_id = resultSet.getString("country_id");
                String country_name = resultSet.getString("country_name");
                int region_id = resultSet.getInt("region_id");
                System.out.println(country_id + "\t" + country_id + "\t" + region_id);
            }
        } catch (SQLException e)
        {
            throw new RuntimeException(e);
        }
        finally
        {
            try
            {
                connection.close();
                statement.close();
            } catch (SQLException e)
            {
                throw new RuntimeException(e);
            }
        }
    }
}
import java.sql.*;

public class Select
{
public static void main(String[] args)
{
Connection connection = null;
Statement statement = null;
try
{
Driver driver = new com.mysql.jdbc.Driver();
DriverManager.registerDriver(driver);
String url = "jdbc:mysql://127.0.0.1:13306/ip";
String user = "root";
String password = "abc123";
connection = DriverManager.getConnection(url,user,password);
System.out.println(connection);
statement = connection.createStatement();
String sql = "SELECT * FROM countries";
ResultSet resultSet = statement.executeQuery(sql);
while(resultSet.next())
{
String country_id = resultSet.getString("country_id");
String country_name = resultSet.getString("country_name");
int region_id = resultSet.getInt("region_id");
System.out.println(country_id + "\t" + country_id + "\t" + region_id);
}
} catch (SQLException e)
{
throw new RuntimeException(e);
}
finally
{
try
{
connection.close();
statement.close();
} catch (SQLException e)
{
throw new RuntimeException(e);
}
}
}
}