com.rimptec.misc

Class datatrans_sql

java.lang.Object

com.rimptec.misc.datatrans_sql

public class datatrans_sql
extends java.lang.Object

Copyright (2005) Rimptec Incorporated

Field Summary

Fields

Modifier and Type	Field and Description
java.util.Date	adate
java.lang.String	assigned_to_email
java.lang.String	assigned_to_name
java.lang.String	assigned_to_phone
java.lang.String	assigned_to_uid
java.util.Date	cdate
java.lang.String	Closed_by
java.util.Date	comdate
java.lang.String	comments
java.lang.String	cwrno
java.lang.String	dest_contact
java.lang.String	dest_contact2
java.lang.String	dest_contact3
java.lang.String	dest_contact4
java.lang.String	dest_contact5
java.lang.String	dest_div
java.lang.String	dest_div2
java.lang.String	dest_div3
java.lang.String	dest_div4
java.lang.String	dest_div5
java.lang.String	dest_email
java.lang.String	dest_email2
java.lang.String	dest_email3
java.lang.String	dest_email4
java.lang.String	dest_email5
java.lang.String	dest_name
java.lang.String	dest_name2
java.lang.String	dest_name3
java.lang.String	dest_name4
java.lang.String	dest_name5
java.lang.String	dest_phone
java.lang.String	dest_phone2
java.lang.String	dest_phone3
java.lang.String	dest_phone4
java.lang.String	dest_phone5
int	destid
int	destid2
int	destid3
int	destid4
int	destid5
java.lang.String	errorMessage
java.lang.String	file_loc
java.lang.String	filename
java.lang.String	filename2
java.lang.String	filename3
java.lang.String	filename4
java.lang.String	filename5
java.lang.String	ftype
java.lang.String	history
java.lang.String	infoMessage1
java.lang.String	infoMessage2
int	isAssigned
int	isClosed
int	isResolved
int	isVerified
mydb	mdb
java.lang.String	orig_email
java.lang.String	orig_name
java.lang.String	orig_phone
java.lang.String	orig_uid
java.lang.String	priority
java.lang.String	projnum
java.util.Date	rdate
java.util.Date	sdate
java.lang.String	transac
int	transno
java.lang.String	used_on
java.util.Date	vdate
java.lang.String	verified_by
java.lang.String	wgroup
java.lang.String	worklog

Constructor Summary

Constructors

Constructor and Description
datatrans_sql()

Method Summary

Modifier and Type	Method and Description
int	add(datatrans cls)
void	connect()
datatrans	createClass(int pid)
int	ctable()
java.lang.String	edit(int pid)
int	runQuery(java.lang.String query)
java.sql.ResultSet	runQueryS(java.lang.String query)
int	update(datatrans 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

transno

public int transno

filename

public java.lang.String filename

filename2

public java.lang.String filename2

filename3

public java.lang.String filename3

filename4

public java.lang.String filename4

filename5

public java.lang.String filename5

file_loc

public java.lang.String file_loc

priority

public java.lang.String priority

projnum

public java.lang.String projnum

dest_name

public java.lang.String dest_name

dest_div

public java.lang.String dest_div

cwrno

public java.lang.String cwrno

destid

public int destid

destid2

public int destid2

destid3

public int destid3

destid4

public int destid4

destid5

public int destid5

dest_contact

public java.lang.String dest_contact

dest_phone

public java.lang.String dest_phone

dest_email

public java.lang.String dest_email

dest_name2

public java.lang.String dest_name2

dest_div2

public java.lang.String dest_div2

dest_contact2

public java.lang.String dest_contact2

dest_phone2

public java.lang.String dest_phone2

dest_email2

public java.lang.String dest_email2

dest_name3

public java.lang.String dest_name3

dest_div3

public java.lang.String dest_div3

dest_contact3

public java.lang.String dest_contact3

dest_phone3

public java.lang.String dest_phone3

dest_email3

public java.lang.String dest_email3

dest_name4

public java.lang.String dest_name4

dest_div4

public java.lang.String dest_div4

dest_contact4

public java.lang.String dest_contact4

dest_phone4

public java.lang.String dest_phone4

dest_email4

public java.lang.String dest_email4

dest_name5

public java.lang.String dest_name5

dest_div5

public java.lang.String dest_div5

dest_contact5

public java.lang.String dest_contact5

dest_phone5

public java.lang.String dest_phone5

dest_email5

public java.lang.String dest_email5

ftype

public java.lang.String ftype

used_on

public java.lang.String used_on

orig_uid

public java.lang.String orig_uid

orig_email

public java.lang.String orig_email

orig_name

public java.lang.String orig_name

orig_phone

public java.lang.String orig_phone

assigned_to_uid

public java.lang.String assigned_to_uid

assigned_to_email

public java.lang.String assigned_to_email

assigned_to_name

public java.lang.String assigned_to_name

assigned_to_phone

public java.lang.String assigned_to_phone

Closed_by

public java.lang.String Closed_by

comments

public java.lang.String comments

wgroup

public java.lang.String wgroup

history

public java.lang.String history

isClosed

public int isClosed

isAssigned

public int isAssigned

isResolved

public int isResolved

sdate

public java.util.Date sdate

adate

public java.util.Date adate

rdate

public java.util.Date rdate

cdate

public java.util.Date cdate

mdb

public mydb mdb

isVerified

public int isVerified

vdate

public java.util.Date vdate

verified_by

public java.lang.String verified_by

transac

public java.lang.String transac

worklog

public java.lang.String worklog

comdate

public java.util.Date comdate

Constructor Detail

datatrans_sql

public datatrans_sql()

Method Detail

connect

public void connect()

add

public int add(datatrans cls)

edit

public java.lang.String edit(int pid)

update

public int update(datatrans cls)

createClass

public datatrans createClass(int pid)

runQuery

public int runQuery(java.lang.String query)

runQueryS

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

ctable

public int ctable()