jdbc 从数据库一张表中查询得到一个值，插入到另一张表中，插入不进去

Question

jdbc 从数据库一张表中查询得到一个值，插入到另一张表中，插入不进去，代码如下：
public void addObjectFields(Company c)throws SQLException{
Connection conn=DBUtil.getConnection();

Statement stmt = conn.createStatement();

String insertSql = " insert into cdpt_object_fields"+
"( object_id,object_name,object_type,field_id,field_auto_id,field_name,field_type,field_level)"+

" values("+ "?,?,?,?,?,?,?,?)";
PreparedStatement ps = conn.prepareStatement(insertSql);

String querySql = "select company_id from cdpt_company_info where cdpt_company_info.company_name= c.getCompany_name()";
ResultSet rs = stmt.executeQuery(querySql);
while (rs.next()) {
ps.setInt(1, rs.getInt("company_name"));

}
ps.setString(2, c.getCompany_name());
ps.setInt(3, 0);
ps.setString(4, c.getIndustry_id());
ps.setInt(5, c.getField_autoid());
ps.setString(6, c.getIndustry_name());
ps.setInt(7, 0);
ps.setString(8, "0");
ps.execute();

}

Answer 1

检查值是否符合另一张表的规范
检查你是否有另一张表的写权限