java 对象数据映射,将行数据从SQL数据映射到Java对象

最新推荐文章于 2023-01-16 00:09:37 发布

张翔炜的运动康复

最新推荐文章于 2023-01-16 00:09:37 发布

阅读量235

点赞数

文章标签： java 对象数据映射

博主推荐使用Spring JDBC库来替代手动的数据库查询映射。Spring JDBC提供连接管理，减少资源关闭的工作，并且包含便利的行映射功能，使得从ResultSet到自定义Java对象的转换更加简洁。通过引入Spring JDBC，可以降低代码的冗余，方便地处理不断增加的列，提高代码维护性。

摘要由CSDN通过智能技术生成

I have a Java class with instance fields (and matching setter methods) that match the column names of a SQL database table. I would like to elegantly fetch a row from the table (into a ResultSet) and map it to an instance of this class.

For example:

I have a "Student" class with instance fields "FNAME", "LNAME", "GRADE" and appropriate getter and setter methods for each.

I also have a SQL table with three columns of the same name.

Right now I am doing something like this:

rs = statement.executeQuery(query);

Student student = new Student();

student.setFNAME(rs.getString("FNAME"));

student.setLNAME(rs.getString("LNAME"));

student.setGRADE(rs.getString("GRADE"));

There has to be a less verbose way of doing this, right? As I add columns this might get really annoying and messy.

解决方案

I recommend using Spring JDBC. You don't need to use the rest of Spring to use their JDBC library. It will manage connections for you (no more closing Connection, Statement, or ResultSet) and has many conveniences, including row mapping.

We've retrofitted legacy code with Spring JDBC with little trouble.

Here is a presentation (PDF) of an overview of Spring JDBC. It's a few years old but it still works essentially the same, even without letting Spring inject the dependencies.