java连接mysql增删改查
时间: 2023-07-07 08:43:40 浏览: 63
好的,以下是Java连接MySQL数据库进行增删改查的示例代码:
1. 导入相关的包
```
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
```
2. 连接MySQL数据库
```
String url = "jdbc:mysql://localhost:3306/test?useSSL=false&serverTimezone=UTC";
String username = "root";
String password = "123456";
Connection conn = null;
try {
Class.forName("com.mysql.cj.jdbc.Driver");
conn = DriverManager.getConnection(url, username, password);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
```
3. 插入数据
```
String sql = "insert into student(name, age, gender) values (?, ?, ?)";
try {
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, "张三");
pstmt.setInt(2, 18);
pstmt.setString(3, "男");
int result = pstmt.executeUpdate();
if (result > 0) {
System.out.println("插入成功!");
} else {
System.out.println("插入失败!");
}
} catch (SQLException e) {
e.printStackTrace();
}
```
4. 更新数据
```
String sql = "update student set age = ? where name = ?";
try {
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, 20);
pstmt.setString(2, "张三");
int result = pstmt.executeUpdate();
if (result > 0) {
System.out.println("更新成功!");
} else {
System.out.println("更新失败!");
}
} catch (SQLException e) {
e.printStackTrace();
}
```
5. 删除数据
```
String sql = "delete from student where name = ?";
try {
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, "张三");
int result = pstmt.executeUpdate();
if (result > 0) {
System.out.println("删除成功!");
} else {
System.out.println("删除失败!");
}
} catch (SQLException e) {
e.printStackTrace();
}
```
6. 查询数据
```
String sql = "select * from student where gender = ?";
try {
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, "男");
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
String name = rs.getString("name");
int age = rs.getInt("age");
String gender = rs.getString("gender");
System.out.println("name: " + name + ", age: " + age + ", gender: " + gender);
}
} catch (SQLException e) {
e.printStackTrace();
}
```
以上就是Java连接MySQL数据库进行增删改查的示例代码,希望对你有所帮助!