JAVA使用JDBC对数据库的内容进行insert操作-----JAVA

旧约Alatus

已于 2023-11-10 23:03:52 修改

阅读量783

点赞数 1

分类专栏： JAVA 文章标签： java sql 数据库 maven jvm mybatis spring

于 2023-05-20 13:32:32 首次发布

本文链接：https://blog.youkuaiyun.com/2201_75960169/article/details/130780541

版权

JAVA 专栏收录该内容

556 篇文章

订阅专栏

该代码示例展示了如何使用Java的JDBCAPI连接到本地MySQL数据库，创建Statement对象，执行SQL插入语句，并处理可能的SQLExceptions。程序尝试将数据(QW,Canada,2)插入到countries表中。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

import java.sql.*;

public class JDBC
{
    public static void main(String[] args)
    {
        Connection conn = 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";
            conn = DriverManager.getConnection(url,user,password);
            System.out.println(conn);
            statement = conn.createStatement();
            String sql = "insert into countries(country_id,country_name,region_id) values('QW','Canada',2)";
            int i = statement.executeUpdate(sql);
            if(i == 1)
            {
                System.out.println("保存成功");
            }
            else
            {
                System.out.println("失败");
            }
        }
        catch (SQLException e)
        {
            throw new RuntimeException(e);
        }
        finally
        {
            if(statement != null)
            {
                try {
                    statement.close();
                } catch (SQLException e) {
                    throw new RuntimeException(e);
                }
            }
            if(conn != null)
            {
                try {
                    conn.close();
                } catch (SQLException e) {
                    throw new RuntimeException(e);
                }
            }
        }
    }
}
import java.sql.*;

public class JDBC
{
public static void main(String[] args)
{
Connection conn = 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";
conn = DriverManager.getConnection(url,user,password);
System.out.println(conn);
statement = conn.createStatement();
String sql = "insert into countries(country_id,country_name,region_id) values('QW','Canada',2)";
int i = statement.executeUpdate(sql);
if(i == 1)
{
System.out.println("保存成功");
}
else
{
System.out.println("失败");
}
}
catch (SQLException e)
{
throw new RuntimeException(e);
}
finally
{
if(statement != null)
{
try {
statement.close();
} catch (SQLException e) {
throw new RuntimeException(e);
}
}
if(conn != null)
{
try {
conn.close();
} catch (SQLException e) {
throw new RuntimeException(e);
}
}
}
}
}