@Override public void addPerson(Person newPerson) { String sql = "insert into person values('"+newPerson.getUserAccount()+"','"+newPerson.getUserName()+"','"+newPerson.getUserSex()+"','"+newPerson.getUserBirthday()+"','"+newPerson.getUserIdCard()+"','"+newPerson.getUserPassword()+"',"+newPerson.getUserIdentify()+",'"+newPerson.getUserOtherName()+"')"; Deal.deal(sql); }改为自写的orm
时间: 2024-03-01 22:50:54 浏览: 19
将上面的代码改为自写的 ORM,可以先定义一个 PersonDao 接口,然后使用 JDBC 的 PreparedStatement 来实现该接口的方法,代码如下:
```
public interface PersonDao {
void addPerson(Person newPerson) throws SQLException;
}
public class PersonDaoImpl implements PersonDao {
private String url;
private String username;
private String password;
public PersonDaoImpl(String url, String username, String password) {
this.url = url;
this.username = username;
this.password = password;
}
@Override
public void addPerson(Person newPerson) throws SQLException {
String sql = "INSERT INTO person VALUES (?, ?, ?, ?, ?, ?, ?, ?)";
try (Connection conn = DriverManager.getConnection(url, username, password);
PreparedStatement ps = conn.prepareStatement(sql)) {
ps.setString(1, newPerson.getUserAccount());
ps.setString(2, newPerson.getUserName());
ps.setString(3, newPerson.getUserSex());
ps.setString(4, newPerson.getUserBirthday());
ps.setString(5, newPerson.getUserIdCard());
ps.setString(6, newPerson.getUserPassword());
ps.setInt(7, newPerson.getUserIdentify());
ps.setString(8, newPerson.getUserOtherName());
ps.executeUpdate();
}
}
}
```
这样就可以通过调用 PersonDaoImpl 的 addPerson 方法来添加一个 Person 对象到数据库中了。
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.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)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)