public void addObjectFields(Company c)throws SQLException{
Connection conn=DBUtil.getConnection();
String sql=" insert into cdpt_object_fields"+
"( object_id,object_name,object_type,field_id,field_auto_id,field_name,field_type,field_level)"+
" values("+ "select company_id from cdpt_company_info where company_name=c.getCompany_name(),?,?,?,?,?,?,?)";
PreparedStatement ps=conn.prepareStatement(sql);
ps.setString(1, c.getCompany_name());
ps.setInt(2, 0);
ps.setString(3, c.getIndustry_id());
ps.setInt(4, c.getField_autoid());
ps.setString(5, c.getIndustry_name());
ps.setInt(6, 0);
ps.setString(7, "0");
ps.execute();
}
object_id是从cdpt_company_info表查询得到的,把他插入到cdpt_object_fields表,两个表的company_name一样