📄 docasefactory.java
字号:
pstmt.setString(7, t_ssrfl);
pstmt.setString(8, t_jzfl);
pstmt.setString(9, b_mc);
pstmt.setString(10, b_zch);
pstmt.setString(11, b_qylx);
pstmt.setString(12, sssjje);
pstmt.setString(13, whjjss);
pstmt.setString(14, jspcje);
pstmt.setString(15, jbpcje);
pstmt.setString(16, sfcf);
pstmt.setString(17, sfyjbmcl);
pstmt.setString(18, sfqq);
pstmt.setString(19, sfcg);
pstmt.setString(20, obj.gettjjg());
pstmt.setString(21, djbh);
pstmt.executeUpdate();
}
catch (Exception e) {
e.printStackTrace();
}
finally {
try {
pstmt.close();
}
catch (Exception e) {
e.printStackTrace();
}
try {
con.close();
}
catch (Exception e) {
e.printStackTrace();
}
}
}
public void editJmwlspaj(U_jmwlspajImp obj){
Connection con = null;
PreparedStatement pstmt = null;
try {
con = DbConnectionManager.getConnection();
pstmt = con.prepareStatement(Q_U_jmwlspaj_edit);
String djbh = obj.getdjbh();
String ajbh = obj.getajbh();
java.util.Date tjrq = obj.gettjrq();
String badw = obj.getbadw();
String bar = obj.getbar();
String t_tssplb = obj.gett_tssplb();
String t_qqxwfl = obj.gett_qqxwfl();
String t_ssrfl = obj.gett_ssrfl();
String t_jzfl = obj.gett_jzfl();
String b_mc = obj.getb_mc();
String b_zch = obj.getb_zch();
String b_qylx = obj.getb_qylx();
String ajje = obj.getajje();
String msje = obj.getmsje();
String fkje = obj.getfkje();
String sfla = obj.getsfla();
String sfyssf = obj.getsfyssf();
String sftjzd = obj.getsftjzd();
String sfdxzz = obj.getsfdxzz();
String sfsc = obj.getsfsc();
String sfjmsc = obj.getsfjmsc();
int dhwd = obj.getdhwd();
String sfdxzdaj = obj.getsfdxzdaj();
String ksaj = obj.getksaj();
String qgaj = obj.getqgaj();
String swaj = obj.getswaj();
String thaj = obj.getthaj();
String lfaj = obj.getlfaj();
String kfaj = obj.getkfaj();
String zlaj = obj.getzlaj();
int shoushang = obj.getshoushang();
int siwang = obj.getsiwang();
pstmt.setString(1, ajbh);
pstmt.setString(2, StringUtils.SimpleDateFormat(tjrq, dateFormat));
pstmt.setString(3, badw);
pstmt.setString(4, bar);
pstmt.setString(5, t_tssplb);
pstmt.setString(6, t_qqxwfl);
pstmt.setString(7, t_ssrfl);
pstmt.setString(8, t_jzfl);
pstmt.setString(9, b_mc);
pstmt.setString(10, b_zch);
pstmt.setString(11, b_qylx);
pstmt.setString(12, ajje);
pstmt.setString(13, msje);
pstmt.setString(14, fkje);
pstmt.setString(15, sfla);
pstmt.setString(16, sfyssf);
pstmt.setString(17, sftjzd);
pstmt.setString(18, sfdxzz);
pstmt.setString(19, sfsc);
pstmt.setString(20, sfjmsc);
pstmt.setInt(21, dhwd);
pstmt.setString(22, sfdxzdaj);
pstmt.setString(23, ksaj);
pstmt.setString(24, qgaj);
pstmt.setString(25, swaj);
pstmt.setString(26, thaj);
pstmt.setString(27, lfaj);
pstmt.setString(28, kfaj);
pstmt.setString(29, zlaj);
pstmt.setInt(30, shoushang);
pstmt.setInt(31, siwang);
pstmt.setString(32, obj.gettjjg());
pstmt.setString(33, djbh);
pstmt.executeUpdate();
}
catch (Exception e) {
e.printStackTrace();
}
finally {
try {
pstmt.close();
}
catch (Exception e) {
e.printStackTrace();
}
try {
con.close();
}
catch (Exception e) {
e.printStackTrace();
}
}
}
public void editQhxfzqyaj(U_qhxfzqyajImp obj){
Connection con = null;
PreparedStatement pstmt = null;
try {
con = DbConnectionManager.getConnection();
pstmt = con.prepareStatement(Q_U_qhxfzqyaj_edit);
String djbh = obj.getdjbh();
String ajbh = obj.getajbh();
java.util.Date tjrq = obj.gettjrq();
String badw = obj.getbadw();
String bar = obj.getbar();
String t_tssplb = obj.gett_tssplb();
String t_qqxwfl = obj.gett_qqxwfl();
String t_ssrfl = obj.gett_ssrfl();
String t_jzfl = obj.gett_jzfl();
String b_mc = obj.getb_mc();
String b_zch = obj.getb_zch();
String b_qylx = obj.getb_qylx();
String ajje = obj.getajje();
String msje = obj.getmsje();
String fkje = obj.getfkje();
String sfla = obj.getsfla();
String sfyssf = obj.getsfyssf();
String sftjzd = obj.getsftjzd();
String sfdxzz = obj.getsfdxzz();
int dyzfry = obj.getdyzfry();
int dyzfcl = obj.getdyzfcl();
int jcsc = obj.getjcsc();
int jcqy = obj.getjcqy();
int blkf = obj.getblkf();
int shoushang = obj.getshoushang();
int siwang = obj.getsiwang();
pstmt.setString(1, ajbh);
pstmt.setString(2, StringUtils.SimpleDateFormat(tjrq, dateFormat));
pstmt.setString(3, badw);
pstmt.setString(4, bar);
pstmt.setString(5, t_tssplb);
pstmt.setString(6, t_qqxwfl);
pstmt.setString(7, t_ssrfl);
pstmt.setString(8, t_jzfl);
pstmt.setString(9, b_mc);
pstmt.setString(10, b_zch);
pstmt.setString(11, b_qylx);
pstmt.setString(12, ajje);
pstmt.setString(13, msje);
pstmt.setString(14, fkje);
pstmt.setString(15, sfla);
pstmt.setString(16, sfyssf);
pstmt.setString(17, sftjzd);
pstmt.setString(18, sfdxzz);
pstmt.setInt(19, dyzfry);
pstmt.setInt(20, dyzfcl);
pstmt.setInt(21, jcsc);
pstmt.setInt(22, jcqy);
pstmt.setInt(23, blkf);
pstmt.setInt(24, shoushang);
pstmt.setInt(25, siwang);
pstmt.setString(26, obj.gettjjg());
pstmt.setString(27, obj.getsfyjbmcl());
pstmt.setString(28, djbh);
pstmt.executeUpdate();
}
catch (Exception e) {
e.printStackTrace();
}
finally {
try {
pstmt.close();
}
catch (Exception e) {
e.printStackTrace();
}
try {
con.close();
}
catch (Exception e) {
e.printStackTrace();
}
}
}
public ArrayList getxztjaj(String sql){
ArrayList list = new ArrayList();
Connection con = null;
PreparedStatement pstmt = null;
try {
con = DbConnectionManager.getConnection();
pstmt = con.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
U_xztjajImp obj = new U_xztjajImp();
try{
obj = setObjct(obj, rs);
}catch(Exception e){}
list.add(obj);
}
}
catch (SQLException sqle) {
sqle.printStackTrace();
}
finally {
try {
pstmt.close();
}
catch (Exception e) {
e.printStackTrace();
}
try {
con.close();
}
catch (Exception e) {
e.printStackTrace();
}
}
return list;
}
public ArrayList getqhxfzqyaj(String sql){
ArrayList list = new ArrayList();
Connection con = null;
PreparedStatement pstmt = null;
try {
con = DbConnectionManager.getConnection();
pstmt = con.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
U_qhxfzqyajImp obj = new U_qhxfzqyajImp();
try{
obj = setObjct(obj, rs);
}catch(Exception e){}
list.add(obj);
}
}
catch (SQLException sqle) {
sqle.printStackTrace();
}
finally {
try {
pstmt.close();
}
catch (Exception e) {
e.printStackTrace();
}
try {
con.close();
}
catch (Exception e) {
e.printStackTrace();
}
}
return list;
}
public ArrayList getjmwlspaj(String sql){
ArrayList list = new ArrayList();
Connection con = null;
PreparedStatement pstmt = null;
try {
con = DbConnectionManager.getConnection();
pstmt = con.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
U_jmwlspajImp obj = new U_jmwlspajImp();
try{
obj = setObjct(obj, rs);
}catch(Exception e){}
list.add(obj);
}
}
catch (SQLException sqle) {
sqle.printStackTrace();
}
finally {
try {
pstmt.close();
}
catch (Exception e) {
e.printStackTrace();
}
try {
con.close();
}
catch (Exception e) {
e.printStackTrace();
}
}
return list;
}
private U_xztjajImp setObjct(U_xztjajImp obj,ResultSet rs) throws Exception {
obj = new U_xztjajImp();
obj.setdjbh(rs.getString("djbh"));
obj.setajbh(rs.getString("ajbh"));
obj.settjrq(StringUtils.handleDate(rs.getString("tjrq"), dateFormat));
obj.setbadw(rs.getString("badw"));
obj.setbar(rs.getString("bar"));
obj.sett_tssplb(rs.getString("t_tssplb"));
obj.sett_ssnrb(rs.getString("t_ssnrb"));
obj.sett_ssrfl(rs.getString("t_ssrfl"));
obj.sett_jzfl(rs.getString("t_jzfl"));
obj.setb_mc(rs.getString("b_mc"));
obj.setb_zch(rs.getString("b_zch"));
obj.setb_qylx(rs.getString("b_qylx"));
obj.setsssjje(rs.getString("sssjje"));
obj.setwhjjss(rs.getString("whjjss"));
obj.setjspcje(rs.getString("jspcje"));
obj.setjbpcje(rs.getString("jbpcje"));
obj.setsfcf(rs.getString("sfcf"));
obj.setsfyjbmcl(rs.getString("sfyjbmcl"));
obj.setsfqq(rs.getString("sfqq"));
obj.setsfcg(rs.getString("sfcg"));
obj.settjjg(rs.getString("tjjg"));
;
return obj;
}
private U_jmwlspajImp setObjct(U_jmwlspajImp obj, ResultSet rs) throws
Exception {
obj = new U_jmwlspajImp();
obj.setdjbh(rs.getString("djbh"));
obj.setajbh(rs.getString("ajbh"));
obj.settjrq(StringUtils.handleDate(rs.getString("tjrq"), dateFormat));
obj.setbadw(rs.getString("badw"));
obj.setbar(rs.getString("bar"));
obj.sett_tssplb(rs.getString("t_tssplb"));
obj.sett_qqxwfl(rs.getString("t_qqxwfl"));
obj.sett_ssrfl(rs.getString("t_ssrfl"));
obj.sett_jzfl(rs.getString("t_jzfl"));
obj.setb_mc(rs.getString("b_mc"));
obj.setb_zch(rs.getString("b_zch"));
obj.setb_qylx(rs.getString("b_qylx"));
obj.setajje(rs.getString("ajje"));
obj.setmsje(rs.getString("msje"));
obj.setfkje(rs.getString("fkje"));
obj.setsfla(rs.getString("sfla"));
obj.setsfyssf(rs.getString("sfyssf"));
obj.setsftjzd(rs.getString("sftjzd"));
obj.setsfdxzz(rs.getString("sfdxzz"));
obj.setsfsc(rs.getString("sfsc"));
obj.setsfjmsc(rs.getString("sfjmsc"));
obj.setdhwd(rs.getInt("dhwd"));
obj.setsfdxzdaj(rs.getString("sfdxzdaj"));
obj.setksaj(rs.getString("ksaj"));
obj.setqgaj(rs.getString("qgaj"));
obj.setswaj(rs.getString("swaj"));
obj.setthaj(rs.getString("thaj"));
obj.setlfaj(rs.getString("lfaj"));
obj.setkfaj(rs.getString("kfaj"));
obj.setzlaj(rs.getString("zlaj"));
obj.setshoushang(rs.getInt("shoushang"));
obj.setsiwang(rs.getInt("siwang"));
obj.settjjg(rs.getString("tjjg"));
;
return obj;
}
private U_qhxfzqyajImp setObjct(U_qhxfzqyajImp obj, ResultSet rs) throws
Exception {
obj = new U_qhxfzqyajImp();
obj.setdjbh(rs.getString("djbh"));
obj.setajbh(rs.getString("ajbh"));
obj.settjrq(StringUtils.handleDate(rs.getString("tjrq"), dateFormat));
obj.setbadw(rs.getString("badw"));
obj.setbar(rs.getString("bar"));
obj.sett_tssplb(rs.getString("t_tssplb"));
obj.sett_qqxwfl(rs.getString("t_qqxwfl"));
obj.sett_ssrfl(rs.getString("t_ssrfl"));
obj.sett_jzfl(rs.getString("t_jzfl"));
obj.setb_mc(rs.getString("b_mc"));
obj.setb_zch(rs.getString("b_zch"));
obj.setb_qylx(rs.getString("b_qylx"));
obj.setajje(rs.getString("ajje"));
obj.setmsje(rs.getString("msje"));
obj.setfkje(rs.getString("fkje"));
obj.setsfla(rs.getString("sfla"));
obj.setsfyssf(rs.getString("sfyssf"));
obj.setsftjzd(rs.getString("sftjzd"));
obj.setsfdxzz(rs.getString("sfdxzz"));
obj.setdyzfry(rs.getInt("dyzfry"));
obj.setdyzfcl(rs.getInt("dyzfcl"));
obj.setjcsc(rs.getInt("jcsc"));
obj.setjcqy(rs.getInt("jcqy"));
obj.setblkf(rs.getInt("blkf"));
obj.setshoushang(rs.getInt("shoushang"));
obj.setsiwang(rs.getInt("siwang"));
;
//tjjg
obj.settjjg(rs.getString("tjjg"));
obj.setsfyjbmcl(rs.getString("sfyjbmcl"));
return obj;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -