写一个通用java类,java类转化为mysql的insert语句通用方法
时间: 2023-05-19 14:01:23 浏览: 402
非常感谢您的提问!以下是一个通用的Java类,可以将Java对象转换为MySQL的INSERT语句:
```java
public class MySQLInsertGenerator {
public static String generateInsertStatement(String tableName, Object object) throws IllegalAccessException {
StringBuilder sb = new StringBuilder();
sb.append("INSERT INTO ");
sb.append(tableName);
sb.append(" (");
Field[] fields = object.getClass().getDeclaredFields();
for (int i = 0; i < fields.length; i++) {
fields[i].setAccessible(true);
sb.append(fields[i].getName());
if (i != fields.length - 1) {
sb.append(", ");
}
}
sb.append(") VALUES (");
for (int i = 0; i < fields.length; i++) {
fields[i].setAccessible(true);
Object value = fields[i].get(object);
if (value instanceof String) {
sb.append("'");
sb.append(value);
sb.append("'");
} else {
sb.append(value);
}
if (i != fields.length - 1) {
sb.append(", ");
}
}
sb.append(");");
return sb.toString();
}
}
```
使用方法如下:
```java
public class Main {
public static void main(String[] args) throws IllegalAccessException {
User user = new User("John", "Doe", 30);
String insertStatement = MySQLInsertGenerator.generateInsertStatement("users", user);
System.out.println(insertStatement);
}
}
class User {
private String firstName;
private String lastName;
private int age;
public User(String firstName, String lastName, int age) {
this.firstName = firstName;
this.lastName = lastName;
this.age = age;
}
}
```
输出结果为:
```
INSERT INTO users (firstName, lastName, age) VALUES ('John', 'Doe', 30);
```
希望这个类能够帮助您!
相关推荐
![application/x-rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)