expenses

java.lang.Object
- com.rimptec.expenses.expenses_sql

public class expenses_sql
extends java.lang.Object

Field Summary

Fields
Modifier and Type	Field and Description
`double`	`amount`
`java.lang.String`	`appr_by_uid`
`java.lang.String`	`ca_busmile`
`java.lang.String`	`ca_carnum`
`double`	`ca_gas`
`double`	`ca_parking`
`java.lang.String`	`ca_permile`
`double`	`ca_washing`
`java.lang.String`	`cardRef`
`java.lang.String`	`comments`
`java.lang.String`	`emp_uid`
`java.lang.String`	`ent_guest_emp`
`java.lang.String`	`ent_guestname`
`java.lang.String`	`ent_place`
`java.lang.String`	`errorMessage`
`int`	`estatus`
`java.util.Date`	`exp_adate`
`java.util.Date`	`expdate`
`int`	`expid`
`int`	`expmainid`
`int`	`exptype`
`int`	`ftype`
`java.lang.String`	`infoMessage1`
`java.lang.String`	`infoMessage2`
`boolean`	`isApproved`
`java.util.Date`	`ldate`
`java.lang.String`	`luser`
`mydb`	`mdb`
`double`	`pa_milage`
`int`	`paidByCC`
`java.lang.String`	`projNo`
`java.lang.String`	`purpose`
`java.util.Date`	`r_date`
`double`	`rate`
`int`	`unit`

Constructor Summary

Constructors
Constructor and Description

expenses_sql()

Constructors
Constructor and Description
`expenses_sql()`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`int`	`add(expenses cls)`
`void`	`connect()`
`expenses`	`createClass(int pid)`
`int`	`ctable()`
`java.lang.String`	`edit(int pid)`
`java.util.Vector`	`getVector(int pid)`
`int`	`runQuery(java.lang.String query)`
`java.sql.ResultSet`	`runQueryS(java.lang.String query)`
`int`	`update(expenses cls)`

Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

errorMessage
```
public java.lang.String errorMessage
```

infoMessage1
```
public java.lang.String infoMessage1
```

infoMessage2
```
public java.lang.String infoMessage2
```

expid
```
public int expid
```

expmainid
```
public int expmainid
```

exptype
```
public int exptype
```

projNo
```
public java.lang.String projNo
```

expdate
```
public java.util.Date expdate
```

amount
```
public double amount
```

emp_uid
```
public java.lang.String emp_uid
```

r_date
```
public java.util.Date r_date
```

purpose
```
public java.lang.String purpose
```

pa_milage
```
public double pa_milage
```

unit
```
public int unit
```

rate
```
public double rate
```

ent_guestname
```
public java.lang.String ent_guestname
```

ent_guest_emp
```
public java.lang.String ent_guest_emp
```

ent_place
```
public java.lang.String ent_place
```

ca_carnum
```
public java.lang.String ca_carnum
```

ca_busmile
```
public java.lang.String ca_busmile
```

ca_permile
```
public java.lang.String ca_permile
```

ca_gas
```
public double ca_gas
```

ca_parking
```
public double ca_parking
```

ca_washing
```
public double ca_washing
```

comments
```
public java.lang.String comments
```

exp_adate
```
public java.util.Date exp_adate
```

isApproved
```
public boolean isApproved
```

appr_by_uid
```
public java.lang.String appr_by_uid
```

luser
```
public java.lang.String luser
```

estatus
```
public int estatus
```

ldate
```
public java.util.Date ldate
```

mdb
```
public mydb mdb
```

paidByCC
```
public int paidByCC
```

cardRef
```
public java.lang.String cardRef
```

ftype
```
public int ftype
```

Constructor Detail
- expenses_sql
```
public expenses_sql()
```

Method Detail

connect
```
public void connect()
```

add
```
public int add(expenses cls)
```

edit

public java.lang.String edit(int pid)

update
```
public int update(expenses cls)
```

createClass
```
public expenses createClass(int pid)
```

getVector

public java.util.Vector getVector(int pid)

runQuery

public int runQuery(java.lang.String query)

runQueryS

public java.sql.ResultSet runQueryS(java.lang.String query)

ctable
```
public int ctable()
```

Class expenses_sql

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

errorMessage

infoMessage1

infoMessage2

expid

expmainid

exptype

projNo

expdate

amount

emp_uid

r_date

purpose

pa_milage

unit

rate

ent_guestname

ent_guest_emp

ent_place

ca_carnum

ca_busmile

ca_permile

ca_gas

ca_parking

ca_washing

comments

exp_adate

isApproved

appr_by_uid

luser

estatus

ldate

mdb

paidByCC

cardRef

ftype

Constructor Detail

expenses_sql

Method Detail

connect

add

edit

update

createClass

getVector

runQuery

runQueryS

ctable