如何使用Java将数据插入到mysql中 [英] How to insert data into mysql using Java

问题描述

我正在尝试使用Java将数据插入到mysql数据库中。我使用以下代码从数据库中获取数据，它工作正常。

I am trying to insert data into mysql database using Java. I am using the following code to fetch data from database and it is working fine.

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class DbTest {

public static void main (String[] args) throws Exception{


    // Accessing Driver From Jar File
    Class.forName("com.mysql.jdbc.Driver");

    //DB Connection
    Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","");  

    // MySQL Query
    PreparedStatement statement= con.prepareStatement("SELECT * FROM jam WHERE id='1'");

    //Creating Variable to execute query
    ResultSet result=statement.executeQuery();

    while(result.next()){

        System.out.println(result.getString(2));

    }

  }


  }

要插入数据，我试过上面的代码只替换

To Insert data, I have tried the above code only replacing

PreparedStatement statement= con.prepareStatement("SELECT * FROM jam 
 WHERE id='1'");

with

 PreparedStatement statement= con.prepareStatement("INSERT INTO jam(id,name) 
 VALUES ('','Charlie Sheen')");

但它显示出一些错误。你能否告诉我我的代码中的问题在哪里？

But its showing some errors. Could you please tell me where is the problem in my code.

谢谢:)

推荐答案

如果您的主键是自动增量，你可以试试这个;

If your primary key is auto increment,you can try this;

  PreparedStatement statement= con.prepareStatement("INSERT INTO jam(name) 
     VALUES (?)");

    statement.setString(1,"Charlie Sheen");

statement.execute();

这篇关于如何使用Java将数据插入到mysql中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！