jdbc插入数据库数据
时间: 2023-05-20 12:04:59 浏览: 49
可以使用以下代码将数据插入数据库:
```
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class JdbcInsertExample {
private static final String INSERT_QUERY = "INSERT INTO users (name, email, age) VALUES (?, ?, ?)";
public static void main(String[] args) {
String url = "jdbc:mysql://localhost:3306/mydatabase";
String username = "root";
String password = "password";
try (Connection conn = DriverManager.getConnection(url, username, password);
PreparedStatement stmt = conn.prepareStatement(INSERT_QUERY)) {
stmt.setString(1, "John Doe");
stmt.setString(2, "johndoe@email.com");
stmt.setInt(3, 30);
int rowsInserted = stmt.executeUpdate();
if (rowsInserted > 0) {
System.out.println("A new user was inserted successfully!");
}
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}
```
这个例子演示了如何使用 JDBC 将数据插入 MySQL 数据库。在这个例子中,我们使用了 PreparedStatement 对象来执行 SQL 查询,这样可以避免 SQL 注入攻击。