private void init(Session s) {
initComponents();
attsetSave = new PreparedSentence(s,
"INSERT INTO ATTRIBUTESETINSTANCE (ID, ATTRIBUTESET_ID, DESCRIPTION) VALUES (?, ?, ?)",
new SerializerWriteBasic(Datas.STRING, Datas.STRING, Datas.STRING));
attinstSave = new PreparedSentence(s,
"INSERT INTO ATTRIBUTEINSTANCE(ID, ATTRIBUTESETINSTANCE_ID, ATTRIBUTE_ID, VALUE) VALUES (?, ?, ?, ?)",
new SerializerWriteBasic(Datas.STRING, Datas.STRING, Datas.STRING, Datas.STRING));
attsetSent = new PreparedSentence(s,
"SELECT ID, NAME FROM ATTRIBUTESET WHERE ID = ?",
SerializerWriteString.INSTANCE,
new SerializerRead() { public Object readValues(DataRead dr) throws BasicException {
return new AttributeSetInfo(dr.getString(1), dr.getString(2));
}});
attsetinstExistsSent = new PreparedSentence(s,
"SELECT ID FROM ATTRIBUTESETINSTANCE WHERE ATTRIBUTESET_ID = ? AND DESCRIPTION = ?",
new SerializerWriteBasic(Datas.STRING, Datas.STRING),
SerializerReadString.INSTANCE);
attinstSent = new PreparedSentence(s, "SELECT A.ID, A.NAME, " + s.DB.CHAR_NULL() + ", " + s.DB.CHAR_NULL() + " " +
"FROM ATTRIBUTEUSE AU JOIN ATTRIBUTE A ON AU.ATTRIBUTE_ID = A.ID " +
"WHERE AU.ATTRIBUTESET_ID = ? " +
"ORDER BY AU.LINENO",
SerializerWriteString.INSTANCE,
new SerializerRead() { public Object readValues(DataRead dr) throws BasicException {
return new AttributeInstInfo(dr.getString(1), dr.getString(2), dr.getString(3), dr.getString(4));
}});
attinstSent2 = new PreparedSentence(s, "SELECT A.ID, A.NAME, AI.ID, AI.VALUE " +
"FROM ATTRIBUTEUSE AU JOIN ATTRIBUTE A ON AU.ATTRIBUTE_ID = A.ID LEFT OUTER JOIN ATTRIBUTEINSTANCE AI ON AI.ATTRIBUTE_ID = A.ID " +
"WHERE AU.ATTRIBUTESET_ID = ? AND AI.ATTRIBUTESETINSTANCE_ID = ?" +
"ORDER BY AU.LINENO",
new SerializerWriteBasic(Datas.STRING, Datas.STRING),
new SerializerRead() { public Object readValues(DataRead dr) throws BasicException {
return new AttributeInstInfo(dr.getString(1), dr.getString(2), dr.getString(3), dr.getString(4));
}});
attvaluesSent = new PreparedSentence(s, "SELECT VALUE FROM ATTRIBUTEVALUE WHERE ATTRIBUTE_ID = ?",
SerializerWriteString.INSTANCE,
SerializerReadString.INSTANCE);
getRootPane().setDefaultButton(m_jButtonOK);
}