java代码实现MySQL数据库连接和增删改查
时间: 2023-02-27 19:03:30 浏览: 116
要在Java代码中实现MySQL数据库的连接,您需要使用JDBC驱动程序。 以下是连接到MySQL数据库的示例代码:
```
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class MySQLJDBC {
public static void main(String[] args) {
Connection connection = null;
try {
Class.forName("com.mysql.cj.jdbc.Driver");
connection = DriverManager.getConnection("jdbc:mysql://hostname:port/dbname","username", "password");
} catch (SQLException | ClassNotFoundException e) {
System.out.println("连接数据库失败");
e.printStackTrace();
} finally {
try {
if (connection != null) {
connection.close();
}
} catch (SQLException e) {
System.out.println("关闭数据库连接失败");
e.printStackTrace();
}
}
}
}
```
对于数据库的增删改查操作,可以使用Java中的SQL语句执行。 以下是示例代码:
```
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class MySQLJDBC {
public static void main(String[] args) {
Connection connection = null;
Statement statement = null;
try {
Class.forName("com.mysql.cj.jdbc.Driver");
connection = DriverManager.getConnection("jdbc:mysql://hostname:port/dbname","username", "password");
statement = connection.createStatement();
// 插入数据
statement.executeUpdate("INSERT INTO table_name (column1, column2, column3) VALUES (value1, value2, value3)");
// 更新数据
statement.executeUpdate("UPDATE table_name SET column1 = value1 WHERE some_column = some_value");
// 删除数据
statement.executeUpdate("DELETE FROM table_name WHERE some_column = some_value");
// 查询数据
ResultSet resultSet = statement.executeQuery("SELECT * FROM table_name");
while (resultSet.next()) {
// 获取数据
}
} catch (SQLException |