persistance.wSql
Class Sql

Object
  persistance.wSql.Sql

public class Sql
extends Object

Sql est un objet path que tous les composants connaissent

il est le noeud principal de l'appli

Cet objet est un requeteur sql, il s'appuie sur le mappage des tables et par les appels d'interface,
calcule les requètes et met des "Records" à disposition des "Vue"

Sql gére deux types de SGBDR sql : un type embarqué (SqlLite) et un type adressable (Mysql)

__________________________________________________________________________________
A_doc
Licence.

Field Summary

String	baseTable
static int	CHOICEPRINTER
String	clauseFilter
String	clauseGroupBy
static String	CONCAT
(package private) java.sql.Connection	cx
java.util.ArrayList<Object[]>	datas
boolean	debugF2
boolean	debugPrint
static int	DEFPRINTER
static String	FIELDENTER
java.util.ArrayList<Field>	fields
int	g_choicePrinter
int	g_nbList
String	g_optionRupture
int	g_orientation
int	g_rupture
(package private) Gp	gp
String	inferieur
java.util.ArrayList<FieldsJoin>	joins
static String	JoinTableName
static int	LANDSCAPE
static int	MODE
static int	MODE_APPEND
static int	MODE_APPENDUPDATED
static int	MODE_MOVABLE
static int	MODE_SAUVE
static int	MODE_UPDATED
static int	PORTRAIT
java.util.ArrayList<Field>	prints
AbstractFieldsDef	printsFilter
java.sql.ResultSet	rs
(package private) java.sql.ResultSet	rsTmp
static int	RUPTURE_DETAIL
static int	RUPTURE_TOTAL
static int	RUPTURE_TOUS
java.util.ArrayList<Field>	ruptures
static int	SQL_ERROR_HARD
static int	SQL_ERROR_SOFT
(package private) boolean	sqlconcat
(package private) String	sqlPipe
Sql	sqlTwin
(package private) java.sql.Statement	statTmp
static int	STR_BUILD
String	superieur
int	t_AccesMode
static int	t_AccesModeIndex
static int	t_AccesModeRecno
static String	t_bottom
boolean	t_debugQuery
boolean	t_eof
JTextDbF2	t_F2
String	t_F2Debut
static int	t_F2DebutFin
String	t_F2fieldLibe
String	t_F2Fin
JPopup	t_F2Popup
String[]	t_filtre
int	t_FirstFieldInSelectForRsGet
int	t_height
String[]	t_index
int[]	t_indexOrder
static String	t_insert
static int	t_LoadAllField
static int	t_LoadRowid
String	t_moduleIdAide
String	t_moduleIdF2Color
int	t_nbFieldWithRowidForData
int	t_nbLigne
JPlageTimes	t_PLAGETIMES
String	t_Recno
int	t_recnoCol
boolean	t_saveRecno
String	t_seek
(package private) String	t_select
boolean	t_showSearch
java.sql.Statement	t_stat
String	t_table
boolean	t_TmpEof
String	t_TmpRecno
static String	t_top
VueIAcces	taParent
VueIAcces	taThis
VueIAcces	taTwin
int	UPDATED
String[]	v_filtre
String	v_index
String	v_TmpIndex
Vue	vue

Constructor Summary

Sql(Gp gp)
Connexion à la base

Sql(Sql sql)
Création du statement d'une table On conserve le statement ouvert

Sql(Sql sql, String t_table)
Création du statement d'une table

Sql(Sql sql, String t_seek, Vue vue)
Création du statement d'une table

Method Summary

void	addJoin(FieldsJoin join)
void	alterNewTableField()
void	alterNewTableField(boolean confirm)
void	applyPreferences(String user)
void	clearMainFrame(boolean enable)
void	closeCx() On libere la connexion
void	closeT_stat() On libere les tables
void	createTable()
void	createTable(boolean confirm)
void	createTemporarySinceTable()
void	createTemporaryTable(boolean confirm)
void	dBBottomByIndex()
boolean	dBDeleteByRecno()
void	dBExecuteQuerryClose(java.sql.ResultSet rs)
java.sql.ResultSet	dBExecuteQueryOpen(String query)
java.sql.ResultSet	dBExecuteQueryTmp(String query)
boolean	dBExecuteSeekEof(String query)
boolean	dBExecuteUpdate(String query)
void	dBGoRecnoByRecno(String recno)
boolean	dBInsert()
boolean	dBInsert(String[] v_champ)
void	dBMessNotDelete(int type, String mess)
void	dBMessNotInsert(int type, String mess)
void	dBMessNotUpdate(int type, String mess)
void	dBNextPageByIndex()
void	dBSeekByIndex(String v_seek)
void	dbSetDebutFinByIndex()
void	dBSkapresByIndex()
void	dBSkavantByIndex()
void	dBSoftSeekByIndex(String v_seek)
void	dBTopByIndex()
void	dBTruncate()
boolean	dBUpdateByRecno(String[] v_champ)
void	dBUpPageByIndex()
void	debugDatas()
String	debugSql()
void	dispose()
void	dropTable()
void	dropTable(boolean confirm)
void	dropTemporaryTable()
void	dropTemporaryTable(boolean confirm)
protected void	finalize()
AbstractDefaultParam	getAppliParam()
Ms1204	getCbMS1204(int num)
String	getCodeFiche()
double	getDataDouble(String sfield)
int	getDataInt(String sfield)
String	getDataString(String sfield)
String	getdecah(String decamehex)
String	getField(int numField)
String	getField(String t_field)
Field	getFieldDef(int field)
Field	getFieldDef(String nameField)
Gp	getGp()
Gp	getGpAbc()
String	geth()
Image	getImage(String name, boolean transp)
String	getLibeF2()
String	getMenu()
JFrame	getMf()
JPanel	getMjpc()
int	getNumField(String sfield)
String	getOpt2()
String	getOpt3()
String	getOption()
String	getOptionText()
JPanel	getPanelTitleMenuOptionText()
String	getQueryGroupOrderby()
String	getQueryWhereCurrentRowid()
String	getReverseSubstDate(String table, String date)
Sql	getSql()
Sql	getSqlAbc()
String	getUser()
Icon	ImageIcon(Image img, int coef)
void	initData()
void	initFields()
void	insertFromTemporaryTable(String where)
void	insertTemporarySinceTable(String where)
boolean	isCodeBarre(int num)
boolean	isCtrlMask()
boolean	isDevFile()
boolean	isEmptyV_indexUpdated(int row)
boolean	isFieldInIndex(int numfield)
boolean	isImpDot(int num)
boolean	isModeAppend()
boolean	isModeAppendUpdated()
boolean	isModeMovable()
boolean	isModeSauve()
boolean	isModeUpdated()
boolean	isNewTableField()
boolean	isRs()
boolean	isShiftMask()
boolean	isTable(String name)
boolean	isTableExist()
boolean	isTcetorp()
boolean	isV_indexUpdated(int row)
void	loadMenu()
int	notify(String titre, String mess, Object[] option, String nameImage, int defOption)
boolean	readBooleanValue(String table, String where, String index, String value)
double	readDoubleValue(String table, String where, String index, String value)
boolean	readFBooleanValue(String table, String where, String index, String filter, String value)
double	readFDoubleValue(String table, String where, String index, String filter, String value)
int	readFIntValue(String table, String where, String index, String filter, String value)
boolean	readFOBooleanValue(String table, String where, String index, String filter, String order, String value)
double	readFODoubleValue(String table, String where, String index, String filter, String order, String value)
int	readFOIntValue(String table, String where, String index, String filter, String order, String value)
boolean	readFOSeek(String table, String where, String index, String filter, String order)
String	readFOStringValue(String table, String where, String index, String filter, String order, String value)
boolean	readFSeek(String table, String where, String index, String filter)
String	readFStringValue(String table, String where, String index, String filter, String value)
int	readIntValue(String table, String where, String index, String value)
boolean	readOBooleanValue(String table, String where, String index, String order, String value)
double	readODoubleValue(String table, String where, String index, String order, String value)
int	readOIntValue(String table, String where, String index, String order, String value)
boolean	readOSeek(String table, String where, String index, String order)
String	readOStringValue(String table, String where, String index, String order, String value)
boolean	readSeek(String table, String where, String index)
String	readStringValue(String table, String where, String index, String value)
void	removeDbVue(boolean enable)
void	renameTable(String name)
void	renameTable(String name, boolean confirm)
String	restoreLastUserFromSystem()
boolean	restoreRecno()
void	rsLoadRecno()
String	rsReadIndexByIndex(boolean close)
void	rsSeekByLike()
boolean	rsSetDatas()
boolean	rsSetDatas(int lastSelectRow)
void	rsSkip(boolean close)
void	rsSoftSeek()
String	rsSoftSeekIndex(String index)
void	saveRecno()
void	setCursorWait(boolean enabled)
void	setDataDouble(String sfield, double value)
void	setDataInt(String sfield, int value)
void	setDataString(String sfield, String value)
void	setDebugQuery(boolean enable)
void	setDesc(boolean desc)
void	setIcon(AbstractJDialogDb abstractJDialogDb)
void	setMode(int mode)
String	setQuerydoubleCote(String string)
void	setTable(String t_table)
void	setTcetorp()
void	setTextStatus(String west, String center, String east)
void	setTextStatusFiche(String west, String east)
void	setTextStatusFicheEdit(String txt)
void	setUser(String m_user)
void	updateTemporarySinceTable(String values, String where)
boolean	v_indexEqualData(int row)
void	writeValue(String table, String values, String where)
void	writeValueAll(String table, String values)

Methods inherited from class Object

clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

gp

Gp gp

cx

java.sql.Connection cx

rs

public java.sql.ResultSet rs

rsTmp

java.sql.ResultSet rsTmp

statTmp

java.sql.Statement statTmp

sqlPipe

String sqlPipe

t_select

String t_select

sqlconcat

boolean sqlconcat

CONCAT

public static final String CONCAT

See Also:

Constant Field Values

STR_BUILD

public static final int STR_BUILD

See Also:

Constant Field Values

SQL_ERROR_HARD

public static final int SQL_ERROR_HARD

See Also:

Constant Field Values

SQL_ERROR_SOFT

public static final int SQL_ERROR_SOFT

See Also:

Constant Field Values

taThis

public VueIAcces taThis

taTwin

public VueIAcces taTwin

taParent

public VueIAcces taParent

sqlTwin

public Sql sqlTwin

t_stat

public java.sql.Statement t_stat

t_table

public String t_table

baseTable

public String baseTable

t_moduleIdAide

public String t_moduleIdAide

fields

public java.util.ArrayList<Field> fields

datas

public java.util.ArrayList<Object[]> datas

prints

public java.util.ArrayList<Field> prints

ruptures

public java.util.ArrayList<Field> ruptures

JoinTableName

public static final String JoinTableName

See Also:

Constant Field Values

joins

public java.util.ArrayList<FieldsJoin> joins

v_filtre

public String[] v_filtre

t_filtre

public String[] t_filtre

clauseFilter

public String clauseFilter

clauseGroupBy

public String clauseGroupBy

t_indexOrder

public int[] t_indexOrder

t_index

public String[] t_index

v_index

public String v_index

t_seek

public String t_seek

superieur

public String superieur

inferieur

public String inferieur

t_showSearch

public boolean t_showSearch

t_bottom

public static String t_bottom

t_top

public static String t_top

t_Recno

public String t_Recno

t_nbFieldWithRowidForData

public int t_nbFieldWithRowidForData

t_recnoCol

public int t_recnoCol

t_eof

public boolean t_eof

t_FirstFieldInSelectForRsGet

public int t_FirstFieldInSelectForRsGet

t_nbLigne

public int t_nbLigne

t_TmpRecno

public String t_TmpRecno

t_TmpEof

public boolean t_TmpEof

v_TmpIndex

public String v_TmpIndex

t_saveRecno

public boolean t_saveRecno

t_F2

public JTextDbF2 t_F2

t_PLAGETIMES

public JPlageTimes t_PLAGETIMES

t_F2Popup

public JPopup t_F2Popup

t_F2fieldLibe

public String t_F2fieldLibe

t_F2Debut

public String t_F2Debut

t_F2Fin

public String t_F2Fin

t_moduleIdF2Color

public String t_moduleIdF2Color

t_F2DebutFin

public static final int t_F2DebutFin

See Also:

Constant Field Values

t_LoadAllField

public static final int t_LoadAllField

See Also:

Constant Field Values

t_LoadRowid

public static final int t_LoadRowid

See Also:

Constant Field Values

FIELDENTER

public static String FIELDENTER

t_height

public int t_height

UPDATED

public int UPDATED

MODE

public static int MODE

MODE_MOVABLE

public static int MODE_MOVABLE

MODE_UPDATED

public static int MODE_UPDATED

MODE_APPEND

public static int MODE_APPEND

MODE_APPENDUPDATED

public static int MODE_APPENDUPDATED

MODE_SAUVE

public static int MODE_SAUVE

t_AccesMode

public int t_AccesMode

t_AccesModeIndex

public static int t_AccesModeIndex

t_AccesModeRecno

public static int t_AccesModeRecno

t_insert

public static String t_insert

vue

public Vue vue

g_nbList

public int g_nbList

g_orientation

public int g_orientation

g_choicePrinter

public int g_choicePrinter

DEFPRINTER

public static int DEFPRINTER

CHOICEPRINTER

public static int CHOICEPRINTER

printsFilter

public AbstractFieldsDef printsFilter

LANDSCAPE

public static int LANDSCAPE

PORTRAIT

public static int PORTRAIT

g_optionRupture

public String g_optionRupture

g_rupture

public int g_rupture

RUPTURE_TOUS

public static final int RUPTURE_TOUS

See Also:

Constant Field Values

RUPTURE_DETAIL

public static final int RUPTURE_DETAIL

See Also:

Constant Field Values

RUPTURE_TOTAL

public static final int RUPTURE_TOTAL

See Also:

Constant Field Values

debugPrint

public boolean debugPrint

debugF2

public boolean debugF2

t_debugQuery

public boolean t_debugQuery

Constructor Detail

Sql

public Sql(Gp gp)

Connexion à la base

Sql

public Sql(Sql sql)

Création du statement d'une table On conserve le statement ouvert

Parameters:

sql - une connexion

Sql

public Sql(Sql sql,
           String t_seek,
           Vue vue)

Création du statement d'une table

Parameters:

sql - une connexion

t_seek - fiche par défaut

vue - type de vue

Sql

public Sql(Sql sql,
           String t_table)

Création du statement d'une table

Parameters:

sql - une connexion

t_table - nom de la table

Method Detail

closeCx

public void closeCx()

On libere la connexion

closeT_stat

public void closeT_stat()

On libere les tables

addJoin

public void addJoin(FieldsJoin join)

initFields

public void initFields()

initData

public void initData()

getDataString

public String getDataString(String sfield)

getDataDouble

public double getDataDouble(String sfield)

getDataInt

public int getDataInt(String sfield)

setDataString

public void setDataString(String sfield,
                          String value)

setDataDouble

public void setDataDouble(String sfield,
                          double value)

setDataInt

public void setDataInt(String sfield,
                       int value)

getNumField

public int getNumField(String sfield)

getFieldDef

public Field getFieldDef(String nameField)

getFieldDef

public Field getFieldDef(int field)

dBExecuteQueryOpen

public java.sql.ResultSet dBExecuteQueryOpen(String query)

dBExecuteQueryTmp

public java.sql.ResultSet dBExecuteQueryTmp(String query)

dBExecuteQuerryClose

public void dBExecuteQuerryClose(java.sql.ResultSet rs)

saveRecno

public void saveRecno()

restoreRecno

public boolean restoreRecno()

v_indexEqualData

public boolean v_indexEqualData(int row)

isV_indexUpdated

public boolean isV_indexUpdated(int row)

isEmptyV_indexUpdated

public boolean isEmptyV_indexUpdated(int row)

getLibeF2

public String getLibeF2()

isFieldInIndex

public boolean isFieldInIndex(int numfield)

getField

public String getField(int numField)

getField

public String getField(String t_field)

setMode

public void setMode(int mode)

isModeUpdated

public boolean isModeUpdated()

isModeAppend

public boolean isModeAppend()

isModeAppendUpdated

public boolean isModeAppendUpdated()

isModeMovable

public boolean isModeMovable()

isModeSauve

public boolean isModeSauve()

getQueryWhereCurrentRowid

public String getQueryWhereCurrentRowid()

getQueryGroupOrderby

public String getQueryGroupOrderby()

setDesc

public void setDesc(boolean desc)

getReverseSubstDate

public String getReverseSubstDate(String table,
                                  String date)

setQuerydoubleCote

public String setQuerydoubleCote(String string)

dbSetDebutFinByIndex

public void dbSetDebutFinByIndex()

dBTopByIndex

public void dBTopByIndex()

dBBottomByIndex

public void dBBottomByIndex()

dBSkapresByIndex

public void dBSkapresByIndex()

dBSkavantByIndex

public void dBSkavantByIndex()

dBGoRecnoByRecno

public void dBGoRecnoByRecno(String recno)

dBSeekByIndex

public void dBSeekByIndex(String v_seek)

dBSoftSeekByIndex

public void dBSoftSeekByIndex(String v_seek)

dBUpPageByIndex

public void dBUpPageByIndex()

dBNextPageByIndex

public void dBNextPageByIndex()

rsSkip

public void rsSkip(boolean close)

rsReadIndexByIndex

public String rsReadIndexByIndex(boolean close)

isRs

public boolean isRs()

rsSoftSeekIndex

public String rsSoftSeekIndex(String index)

rsSoftSeek

public void rsSoftSeek()

rsLoadRecno

public void rsLoadRecno()

rsSeekByLike

public void rsSeekByLike()

rsSetDatas

public boolean rsSetDatas()

rsSetDatas

public boolean rsSetDatas(int lastSelectRow)

dBInsert

public boolean dBInsert()

dBInsert

public boolean dBInsert(String[] v_champ)

dBUpdateByRecno

public boolean dBUpdateByRecno(String[] v_champ)

dBDeleteByRecno

public boolean dBDeleteByRecno()

dBMessNotInsert

public void dBMessNotInsert(int type,
                            String mess)

dBMessNotUpdate

public void dBMessNotUpdate(int type,
                            String mess)

dBMessNotDelete

public void dBMessNotDelete(int type,
                            String mess)

dBExecuteUpdate

public boolean dBExecuteUpdate(String query)

dBExecuteSeekEof

public boolean dBExecuteSeekEof(String query)

readFOStringValue

public String readFOStringValue(String table,
                                String where,
                                String index,
                                String filter,
                                String order,
                                String value)

readFStringValue

public String readFStringValue(String table,
                               String where,
                               String index,
                               String filter,
                               String value)

readOStringValue

public String readOStringValue(String table,
                               String where,
                               String index,
                               String order,
                               String value)

readStringValue

public String readStringValue(String table,
                              String where,
                              String index,
                              String value)

readFOIntValue

public int readFOIntValue(String table,
                          String where,
                          String index,
                          String filter,
                          String order,
                          String value)

readFIntValue

public int readFIntValue(String table,
                         String where,
                         String index,
                         String filter,
                         String value)

readOIntValue

public int readOIntValue(String table,
                         String where,
                         String index,
                         String order,
                         String value)

readIntValue

public int readIntValue(String table,
                        String where,
                        String index,
                        String value)

readFODoubleValue

public double readFODoubleValue(String table,
                                String where,
                                String index,
                                String filter,
                                String order,
                                String value)

readFDoubleValue

public double readFDoubleValue(String table,
                               String where,
                               String index,
                               String filter,
                               String value)

readODoubleValue

public double readODoubleValue(String table,
                               String where,
                               String index,
                               String order,
                               String value)

readDoubleValue

public double readDoubleValue(String table,
                              String where,
                              String index,
                              String value)

readFOBooleanValue

public boolean readFOBooleanValue(String table,
                                  String where,
                                  String index,
                                  String filter,
                                  String order,
                                  String value)

readFBooleanValue

public boolean readFBooleanValue(String table,
                                 String where,
                                 String index,
                                 String filter,
                                 String value)

readOBooleanValue

public boolean readOBooleanValue(String table,
                                 String where,
                                 String index,
                                 String order,
                                 String value)

readBooleanValue

public boolean readBooleanValue(String table,
                                String where,
                                String index,
                                String value)

readFOSeek

public boolean readFOSeek(String table,
                          String where,
                          String index,
                          String filter,
                          String order)

readFSeek

public boolean readFSeek(String table,
                         String where,
                         String index,
                         String filter)

readOSeek

public boolean readOSeek(String table,
                         String where,
                         String index,
                         String order)

readSeek

public boolean readSeek(String table,
                        String where,
                        String index)

writeValue

public void writeValue(String table,
                       String values,
                       String where)

writeValueAll

public void writeValueAll(String table,
                          String values)

isTableExist

public boolean isTableExist()

isTable

public boolean isTable(String name)

createTable

public void createTable()

createTable

public void createTable(boolean confirm)

createTemporarySinceTable

public void createTemporarySinceTable()

createTemporaryTable

public void createTemporaryTable(boolean confirm)

dropTemporaryTable

public void dropTemporaryTable()

dropTemporaryTable

public void dropTemporaryTable(boolean confirm)

insertTemporarySinceTable

public void insertTemporarySinceTable(String where)

insertFromTemporaryTable

public void insertFromTemporaryTable(String where)

updateTemporarySinceTable

public void updateTemporarySinceTable(String values,
                                      String where)

isNewTableField

public boolean isNewTableField()

alterNewTableField

public void alterNewTableField()

alterNewTableField

public void alterNewTableField(boolean confirm)

dropTable

public void dropTable()

dropTable

public void dropTable(boolean confirm)

renameTable

public void renameTable(String name)

renameTable

public void renameTable(String name,
                        boolean confirm)

dBTruncate

public void dBTruncate()

getCodeFiche

public String getCodeFiche()

debugSql

public String debugSql()

setDebugQuery

public void setDebugQuery(boolean enable)

dispose

public void dispose()

finalize

protected void finalize()

Overrides:

finalize in class Object

debugDatas

public void debugDatas()

getGp

public Gp getGp()

getGpAbc

public Gp getGpAbc()

getMf

public JFrame getMf()

isDevFile

public boolean isDevFile()

getSqlAbc

public Sql getSqlAbc()

getUser

public String getUser()

getOption

public String getOption()

getOptionText

public String getOptionText()

getMenu

public String getMenu()

setUser

public void setUser(String m_user)

setCursorWait

public void setCursorWait(boolean enabled)

setTextStatusFiche

public void setTextStatusFiche(String west,
                               String east)

setTextStatusFicheEdit

public void setTextStatusFicheEdit(String txt)

setTextStatus

public void setTextStatus(String west,
                          String center,
                          String east)

setIcon

public void setIcon(AbstractJDialogDb abstractJDialogDb)

clearMainFrame

public void clearMainFrame(boolean enable)

loadMenu

public void loadMenu()

applyPreferences

public void applyPreferences(String user)

getAppliParam

public AbstractDefaultParam getAppliParam()

isTcetorp

public boolean isTcetorp()

getImage

public Image getImage(String name,
                      boolean transp)

ImageIcon

public Icon ImageIcon(Image img,
                      int coef)

notify

public int notify(String titre,
                  String mess,
                  Object[] option,
                  String nameImage,
                  int defOption)

removeDbVue

public void removeDbVue(boolean enable)

getPanelTitleMenuOptionText

public JPanel getPanelTitleMenuOptionText()

restoreLastUserFromSystem

public String restoreLastUserFromSystem()

getSql

public Sql getSql()

geth

public String geth()

getdecah

public String getdecah(String decamehex)

setTcetorp

public void setTcetorp()

getMjpc

public JPanel getMjpc()

getOpt2

public String getOpt2()

getOpt3

public String getOpt3()

isCodeBarre

public boolean isCodeBarre(int num)

getCbMS1204

public Ms1204 getCbMS1204(int num)

isImpDot

public boolean isImpDot(int num)

isCtrlMask

public boolean isCtrlMask()

isShiftMask

public boolean isShiftMask()

setTable

public void setTable(String t_table)