📄 kaigi_jouhou_004dataaccess.java
字号:
/*
* Copyright (C) 2000, TOA-System Co. All rights reserved.
*/
package dbcommon;
import java.util.*;
import java.sql.*;
import java.text.*;
import exce.*;
import def.*;
import util.*;
import entity.*;
/**
* 偙偺僋儔僗偼丄夛媍忣曬傊傾僋僙僗偡傞偨傔偺僋儔僗偱偡丅<br>
* @version 2.00
* @author TOA
*
* 峏怴棜楌
* <ul>
* <li>僐儊儞僩傪捛壛
* </ul>
*/
public class Kaigi_Jouhou_004DataAccess extends DataAccess{
ChangeField cf = new ChangeField();
Status st = new Status();
public Kaigi_Jouhou_004DataAccess() {}
SimpleDateFormat sdf = new SimpleDateFormat(SISnet.DATE_FMT);
public void lockKaigi_Jouhou_004(Connection con, String whe) {
ResultSet rs = null;
try {
// 偙偺儊僜僢僪偱幚峴偡傞SQL暥偱偡丅
String sql = "SELECT * FROM KAIGI_JOUHOU_004 " + whe + " FOR UPDATE NOWAIT";
pstmt = this.sqlSet(con,sql);
rs = this.exeQuery(pstmt);
int size = 0;
while (rs.next()) {
size = size + 1;
}
if ( size == 0 ) {
throw new MissingFindException("夛媍忣曬"); //Oracle梡偱張棟
}
} catch (MissingFindException misse) {
throw new MissingFindException("夛媍忣曬");
} catch (Exception e) {
throw new OriginalException(e);
} finally {
// Statemet偼丆昁偢close()偟傑偡丅
try {
if (rs != null) rs.close();
if (pstmt != null) pstmt.close();
} catch (Exception ex) { }
}
}
/**
* 夛媍忣曬偺捛壛(Insert)
* @param con DB僪儔僀僶偺URL側偳
* jme Kaigi_Jouhou_004Entity僆僽僕僃僋僩
*/
public void createKaigi_Jouhou_004(Connection con, Kaigi_Jouhou_004Entity ee) {
ResultSet rs = null;
try {
// 偙偺儊僜僢僪偱幚峴偡傞SQL暥偱偡
String sql = "INSERT INTO KAIGI_JOUHOU_004 (" +
"USER_CD,"+
"USER_NM,"+
"BUMON_CD,"+
"BUMON_NM,"+
"STRAT_DATE_TIME,"+
"STRAT_JITEN,"+
"END_DATE_TIME,"+
"END_JITEN,"+
"BEKO,"+
"KUBUN,"+
"UPDATE_USER,"+
"UPDATE_TIME,"+
"OLUPDATE_USER,"+
"OLUPDATE_TIME"+") values (" +
"?," +
"?," +
"?," +
"?," +
"?," +
"?," +
"?," +
"?," +
"?," +
"?," +
"?," +
"SYSDATE," +
"?," +
"SYSDATE)";
pstmt = this.sqlSet(con,sql);
pstmt.setString(1,ee._user_cd);
pstmt.setString(2,ee._user_nm);
pstmt.setString(3,ee._bumon_cd);
pstmt.setString(4,ee._bumon_nm);
pstmt.setDate(5,ee._strat_date_time);
pstmt.setInt(6,ee._strat_jiten);
pstmt.setDate(7,ee._end_date_time);
pstmt.setInt(8,ee._end_jiten);
pstmt.setString(9,ee._beko);
pstmt.setString(10,ee._kubun);
pstmt.setString(11,ee._update_user);
pstmt.setString(12,ee._olupdate_user);
int i = this.exeUpdate(pstmt);
} catch (MissingFindException misse) {
throw new MissingFindException("夛媍忣曬");
} catch (OracleException orae) {
st = orae.getStatus();
throw new OracleException(st);
} catch (SQLException sqle) {
throw new OracleException(sqle);
} catch (Exception e) {
throw new OriginalException(e);
} finally {
// Statemet偼丆昁偢close()偟傑偡丅
try {
if (rs != null) rs.close();
if (pstmt != null) pstmt.close();
} catch (Exception ex) { }
}
}
public Kaigi_Jouhou_004Entity[] findKaigi_Jouhou_004(Connection con,String whe) {
ResultSet rs = null;
try {
// 偙偺儊僜僢僪偱幚峴偡傞SQL暥偱偡丅
String sql = "SELECT DISTINCT USER_CD,USER_NM,BUMON_CD,BUMON_NM,STRAT_DATE_TIME,STRAT_JITEN,END_DATE_TIME,END_JITEN,BEKO,KUBUN,UPDATE_USER,UPDATE_TIME,OLUPDATE_USER,OLUPDATE_TIME FROM KAIGI_JOUHOU_004 ";
if(whe!=null&&!(whe.equals(""))){
sql+=whe;
}
pstmt = this.sqlSet(con,sql);
rs = this.exeQuery(pstmt);
Vector v = new Vector();
while (rs.next()) {
// Entity僆僽僕僃僋僩傪侾偮偮偔傝丆偙傟偵抣傪奿擺偟傑偡丅
Kaigi_Jouhou_004Entity ee = new Kaigi_Jouhou_004Entity();
ee._user_cd =rs.getString("USER_CD"); //幮堳僐乕僪
ee._user_nm =rs.getString("USER_NM"); //幮堳柤
ee._bumon_cd =rs.getString("BUMON_CD"); //晹栧僐乕僪
ee._bumon_nm =rs.getString("BUMON_NM"); //晹栧柤
ee._strat_date_time =rs.getDate("STRAT_DATE_TIME"); //奐巒擔晅
ee._strat_jiten =rs.getInt("STRAT_JITEN"); //奐巒帪揰
ee._end_date_time =rs.getDate("END_DATE_TIME"); //廔椆擔晅
ee._end_jiten =rs.getInt("END_JITEN"); //廔椆帪揰
ee._beko =rs.getString("BEKO"); //旛峫
ee._kubun =rs.getString("KUBUN"); //嬫暘
ee._update_user =rs.getString("UPDATE_USER"); //峏怴幰
ee._update_time =rs.getDate("UPDATE_TIME"); //峏怴擔帪
ee._olupdate_user =rs.getString("OLUPDATE_USER"); //僆儞儔僀儞嵟廔峏怴幰
ee._olupdate_time =rs.getDate("OLUPDATE_TIME"); //僆儞儔僀儞嵟廔峏怴擔帪
v.addElement(ee);
}
// Vector 偐傜 Entity僆僽僕僃僋僩偺攝楍傊堏偟懼偊傑偡丅
int size = v.size();
Kaigi_Jouhou_004Entity[] ees = new Kaigi_Jouhou_004Entity[size];
ees = (Kaigi_Jouhou_004Entity[])v.toArray(ees);
return ees;
} catch (MissingFindException misse) {
throw new MissingFindException("夛媍忣曬");
} catch (OracleException orae) {
st = orae.getStatus();
throw new OracleException(st);
} catch (SQLException sqle) {
throw new OracleException(sqle);
} catch (Exception e) {
throw new OriginalException(e);
} finally {
// Statemet偼丆昁偢close()偟傑偡丅
try {
if (rs != null) rs.close();
if (pstmt != null) pstmt.close();
} catch (Exception ex) { }
}
}
public void updateKaigi_Jouhou_004(Connection con, Kaigi_Jouhou_004Entity ee) {
ResultSet rs = null;
try {
// 懠偺抂枛偱儘僢僋傪偟偰偄側偄偐偳偆偐傪妋偐傔傑偡丅
// 僔儞僌儖僐乕僩偑擖傞偙偲偼偁傝摼側偄乮愝掕僥乕僽儖)
String whe = "WHERE USER_CD = '" + ee._user_cd + "' AND BUMON_CD = '" + ee._bumon_cd + "' AND STRAT_DATE_TIME = to_date('" + sdf.format(ee._strat_date_time)+"','yyyy/mm/dd')"+ " AND STRAT_JITEN = '" + ee._strat_jiten+ "' AND END_DATE_TIME =to_date('" + sdf.format(ee._end_date_time)+"','yyyy/mm/dd')"+ " AND END_JITEN = '" + ee._end_jiten+"'";
this.lockKaigi_Jouhou_004(con, whe);
// 偙偺儊僜僢僪偱幚峴偡傞SQL暥偱偡丅
String sql = "UPDATE KAIGI_JOUHOU_004 SET " +
" USER_CD = ?, " + //幮堳僐乕僪
" USER_NM = ?," + //幮堳柤
" BUMON_CD = ?, " + //晹栧僐乕僪
" BUMON_NM =?, " + //晹栧柤
" STRAT_DATE_TIME=?, " + //奐巒擔晅
" STRAT_JITEN=?, " + //奐巒帪揰
" END_DATE_TIME=?, " + //廔椆擔晅
" END_JITEN=?, " + //廔椆帪揰
" BEKO =?, " + //旛峫
" KUBUN=?, " + //嬫暘
" UPDATE_USER=?, " + //峏怴幰
" UPDATE_TIME=SYSDATE, " + //峏怴擔帪
" OLUPDATE_USER=?, " + //僆儞儔僀儞嵟廔峏怴幰
" OLUPDATE_TIME=SYSDATE "+whe; //僆儞儔僀儞嵟廔峏怴擔帪
pstmt = this.sqlSet(con,sql);
pstmt.setString(1,ee._user_cd);
pstmt.setString(2,ee._user_nm);
pstmt.setString(3,ee._bumon_cd);
pstmt.setString(4,ee._bumon_nm);
pstmt.setDate(5,ee._strat_date_time);
pstmt.setInt(6,ee._strat_jiten);
pstmt.setDate(7,ee._end_date_time);
pstmt.setInt(8,ee._end_jiten);
pstmt.setString(9,ee._beko);
pstmt.setString(10,ee._kubun);
pstmt.setString(11,ee._update_user);
pstmt.setString(12,ee._olupdate_user);
int i = this.exeUpdate(pstmt);
} catch (MissingFindException misse) {
throw new MissingFindException("夛媍忣曬");
} catch (OracleException orae) {
st = orae.getStatus();
throw new OracleException(st);
} catch (SQLException sqle) {
throw new OracleException(sqle);
} catch (Exception e) {
throw new OriginalException(e);
} finally {
// Statemet偼丆昁偢close()偟傑偡丅
try {
if (rs != null) rs.close();
if (pstmt != null) pstmt.close();
} catch (Exception ex) { }
}
}
public void deleteKaigi_Jouhou_004(Connection con, String whe) {
ResultSet rs = null;
try {
// 懠偺抂枛偱儘僢僋傪偟偰偄側偄偐偳偆偐傪妋偐傔傑偡丅
this.lockKaigi_Jouhou_004(con, whe);
// 偙偺儊僜僢僪偱幚峴偡傞SQL暥偱偡丅
String sql = "DELETE KAIGI_JOUHOU_004 " + whe;
pstmt = this.sqlSet(con,sql);
int i = this.exeUpdate(pstmt);
} catch (MissingFindException misse) {
throw new MissingFindException("夛媍忣曬");
} catch (Exception e) {
throw new OriginalException(e);
} finally {
// Statemet偼丆昁偢close()偟傑偡丅
try {
if (rs != null) rs.close();
if (pstmt != null) pstmt.close();
} catch (Exception ex) { }
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -