java 连接数据库并实现添加用户的代码
时间: 2024-05-09 13:18:08 浏览: 10
好的,以下是 Java 连接数据库并实现添加用户的示例代码:
```java
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class AddUser {
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/test";
String username = "root";
String password = "root";
public void addUser(String name, int age, String address) {
Connection conn = null;
PreparedStatement pstmt = null;
try {
Class.forName(driver);
conn = DriverManager.getConnection(url, username, password);
String sql = "insert into user(name, age, address) values(?,?,?)";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, name);
pstmt.setInt(2, age);
pstmt.setString(3, address);
pstmt.executeUpdate();
System.out.println("添加用户成功!");
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (pstmt != null) pstmt.close();
if (conn != null) conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
}
```
调用示例:
```java
AddUser addUser = new AddUser();
addUser.addUser("张三", 25, "北京市朝阳区");
```
以上代码仅供参考,请根据实际情况进行修改和调整。