如果Javabean和数据库字段没有对应,当通过反射去将查询到的字段和属性去对应时,会报反射异常的错误java.lang.NoSuchFieldException
package test_jdbc2;
import java.lang.reflect.Field;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import org.junit.Test;
import jdbc_bean.Job;
import jdbc_util.JDBCUtils;
/**
* 对jobs表执行查询操作
*
* @author Justyhk
*
*/
public class SelectTestFinal {
@Test
public void test() {
Job job = testQueryFinal();
System.out.println(job);
}
public Job testQueryFinal() {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
conn = JDBCUtils.getConnection();
String sql = "SELECT job_id,job_title,min_salary,max_salary FROM jobs where job_id=?;";
ps = conn.prepareStatement(sql);
ps.setObject(1, "AD_VP");