?? syutuketu_jouhou_003dataaccess.java
字號:
/*
* Copyright (C) 2000, TOA-System Co. All rights reserved.
*/
package dbcommon;
import java.util.*;
import java.sql.*;
import entity.*;
import util.*;
import exce.*;
/**
* 偙偺僋儔僗偼丄弌寚忣曬傊傾僋僙僗偡傞偨傔偺僋儔僗偱偡丅<br>
* @version 2.00
* @author TOA
*
* 峏怴棜楌
* <ul>
* <li>僐儊儞僩傪捛壛
* </ul>
*/
public class Syutuketu_Jouhou_003DataAccess extends DataAccess{
ChangeField cf = new ChangeField();
Status st = new Status();
public Syutuketu_Jouhou_003DataAccess() {}
public void lockSyutuketu_Jouhou_003(Connection con, String whe) {
ResultSet rs = null;
try {
// 偙偺儊僜僢僪偱幚峴偡傞SQL暥偱偡丅
String sql = "SELECT * FROM SYUTUKETU_JOUHOU_003 " + 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 Syutuketu_Jouhou_003Entity僆僽僕僃僋僩
*/
public void createSyutuketu_Jouhou_003(Connection con, Syutuketu_Jouhou_003Entity ee) {
ResultSet rs = null;
try {
// 偙偺儊僜僢僪偱幚峴偡傞SQL暥偱偡
String sql = "INSERT INTO SYUTUKETU_JOUHOU_003 (" +
"USER_CD,"+
"USER_NM,"+
"BUMON_CD,"+
"BUMON_NM,"+
"DATE_TIME,"+
"TIKOKU,"+
"SOUTAI,"+
"ZANGYOU,"+
"KETUKIN,"+
"XIUJIA,"+
"SYUTYOU,"+
"START_END_KUBUN,"+
"START_TIME,"+
"END_TIME,"+
"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._date_time);
pstmt.setDouble(6,ee._tikoku);
pstmt.setDouble(7,ee._soutai);
pstmt.setDouble(8,ee._zangyou);
pstmt.setDouble(9,ee._ketukin);
pstmt.setDouble(10,ee._xiujia);
pstmt.setDouble(11,ee._syutyou);
pstmt.setString(12,ee._start_end_kubun);
pstmt.setInt(13,ee._start_time);
pstmt.setInt(14,ee._end_time);
pstmt.setString(15,ee._update_user);
pstmt.setString(16,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 Syutuketu_Jouhou_003Entity[] findSyutuketu_Jouhou_003(Connection con,String whe) {
ResultSet rs = null;
try {
// 偙偺儊僜僢僪偱幚峴偡傞SQL暥偱偡丅
String sql = "SELECT DISTINCT USER_CD,USER_NM,BUMON_CD,BUMON_NM,DATE_TIME,TIKOKU,SOUTAI,ZANGYOU,KETUKIN,XIUJIA,SYUTYOU,START_END_KUBUN,START_TIME,END_TIME,UPDATE_USER,UPDATE_TIME,OLUPDATE_USER,OLUPDATE_TIME FROM SYUTUKETU_JOUHOU_003 ";
if(whe!=null&&!(whe.equals(""))){
sql+=whe;
}
pstmt = this.sqlSet(con,sql);
rs = this.exeQuery(pstmt);
Vector v = new Vector();
while (rs.next()) {
// Entity僆僽僕僃僋僩傪侾偮偮偔傝丆偙傟偵抣傪奿擺偟傑偡丅
Syutuketu_Jouhou_003Entity ee = new Syutuketu_Jouhou_003Entity();
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._date_time =rs.getDate("DATE_TIME"); //擔晅
ee._tikoku =rs.getDouble("TIKOKU"); //抶崗
ee._soutai =rs.getDouble("SOUTAI"); //憗戅
ee._zangyou =rs.getDouble("ZANGYOU"); //巆嬈丂
ee._ketukin =rs.getDouble("KETUKIN"); //寚嬑
ee._xiujia =rs.getDouble("XIUJIA"); //巹帠媥橈
ee._syutyou =rs.getDouble("SYUTYOU"); //弌挘
ee._start_end_kubun =rs.getString("START_END_KUBUN"); //
ee._start_time =rs.getInt("START_TIME"); //弌嬑帪揰
ee._end_time =rs.getInt("END_TIME"); //戅嬑帪揰
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();
Syutuketu_Jouhou_003Entity[] ees = new Syutuketu_Jouhou_003Entity[size];
ees = (Syutuketu_Jouhou_003Entity[])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 updateSyutuketu_Jouhou_003(Connection con, Syutuketu_Jouhou_003Entity ee) {
ResultSet rs = null;
try {
// 懠偺抂枛偱儘僢僋傪偟偰偄側偄偐偳偆偐傪妋偐傔傑偡丅
// 僔儞僌儖僐乕僩偑擖傞偙偲偼偁傝摼側偄乮愝掕僥乕僽儖)
String whe = "WHERE USER_CD = '" + ee._user_cd + "' AND BUMON_CD = '" + ee._bumon_cd + "' AND DATE_TIME = to_date('" + ee._date_time+"','yyyy/mm/dd')" ;
this.lockSyutuketu_Jouhou_003(con, whe);
// 偙偺儊僜僢僪偱幚峴偡傞SQL暥偱偡丅
String sql = "UPDATE SYUTUKETU_JOUHOU_003 SET " +
" USER_CD = ?, " + //幮堳僐乕僪
" USER_NM = ?," + //幮堳柤
" BUMON_CD = ?, " + //晹栧僐乕僪
" BUMON_NM =?, " + //晹栧柤
" DATE_TIME=?, " + //擔晅
" TIKOKU=?, " + //抶崗
" SOUTAI=?, " + //憗戅
" ZANGYOU=?, " + //巆嬈
" KETUKIN =?, " + //寚嬑
" XIUJIA=?, " + //巹帠媥橈
" SYUTYOU=?, " + //弌挘
" START_END_KUBUN=?, " + //
" START_TIME=?, " + //弌嬑帪揰丂
" END_TIME=?, " + //戅嬑帪揰
" 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._date_time);
pstmt.setDouble(6,ee._tikoku);
pstmt.setDouble(7,ee._soutai);
pstmt.setDouble(8,ee._zangyou);
pstmt.setDouble(9,ee._ketukin);
pstmt.setDouble(10,ee._xiujia);
pstmt.setDouble(11,ee._syutyou);
pstmt.setString(12,ee._start_end_kubun);
pstmt.setInt(13,ee._start_time);
pstmt.setInt(14,ee._end_time);
pstmt.setString(15,ee._update_user);
pstmt.setString(16,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 deleteSyutuketu_Jouhou_003(Connection con, String whe) {
ResultSet rs = null;
try {
// 懠偺抂枛偱儘僢僋傪偟偰偄側偄偐偳偆偐傪妋偐傔傑偡丅
this.lockSyutuketu_Jouhou_003(con, whe);
// 偙偺儊僜僢僪偱幚峴偡傞SQL暥偱偡丅
String sql = "DELETE SYUTUKETU_JOUHOU_003 " + 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 + -