• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Paul Clapham
  • Bear Bibeault
  • Jeanne Boyarsky
Sheriffs:
  • Ron McLeod
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Jj Roberts
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • salvin francis
  • Scott Selikoff
  • fred rosenberger

(jdbc+oracle) urgent please!!

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi!
I am in a cofusion for a long to solve a problem in jtable(swing) . If it is single row not a problem ,but in case of multiple rows the problem arise.When one row is updated other records of the table updated.Another problem lies in specific cell delete.
I will be greatful to you if you help me in refining the provided code or by suggestions,references.
package starpharma;
import com.borland.jbcl.layout.*;
import java.sql.*;
import javax.swing.*;
import javax.swing.JTable;
import javax.swing.table.AbstractTableModel;
import javax.swing.table.TableColumn;
import javax.swing.DefaultCellEditor;
import javax.swing.table.TableCellRenderer;
import javax.swing.table.DefaultTableCellRenderer;
import javax.swing.JScrollPane;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.SwingUtilities;
import javax.swing.JOptionPane;
import java.awt.*;
import java.awt.event.*;
/**
* Title:
* Description:
* Copyright: Copyright (c) 2002
* Company: Star Pharma
* @author shaiful;
* @version 1.0
*/
public class RMREntry extends JInternalFrame {
String st[]= new String[]{"Keep below 30 c","Cool place","Deep freeze","Middle Temp.","4 Deg c"};
//String st2[]={};

XYLayout xYLayout1 = new XYLayout();
JLabel lblRawMaterialsID = new JLabel();
JLabel lblRawmaterialsName = new JLabel();
JLabel lblCategory = new JLabel();
JLabel lblStorageType = new JLabel();
JLabel lblRequiredAnalysis = new JLabel();
JLabel lblNote = new JLabel();
JTextField txtRawMaterialsID = new JTextField();
JTextField txtRawMaterialsName = new JTextField();
JTextField txtCategory = new JTextField();
JTextField txtStorageType = new JTextField();
JComboBox cmbCategory = new JComboBox();
JComboBox cmbStorageType = new JComboBox(st);
JTextArea txaNote = new JTextArea();
JButton btnFind = new JButton();
JButton btnAuto = new JButton();
JButton btnDelete = new JButton();
JButton btnSave = new JButton();
JButton btnUpdate = new JButton();
JButton btnCancel = new JButton();
JButton btnShow = new JButton();
JButton btnClose = new JButton();
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
String str = "";
/**
* Code For JTable
*
*/
MyTableModel myModel;
//String anaIDs[]=new String [9999];
int NRows;
Object[][] rowData;
// Connection connection =null;
ResultSet rset = null;
String strRMID="";
String strRMName="";
String strCategory="";
String strStorageType="";
String strNote="";
String sqlID = " ";

JPanel pnl = new JPanel();
XYLayout xYLayout2 = new XYLayout();
JScrollPane spn = new JScrollPane();
JTable tblRequiredAnalysis = new JTable();
public RMREntry() {
super("RMREntry Form",true,true,true,true);
NRows=6;
rowData = new Object[9999][8];
try {
jbInit();
}
catch(Exception e) {
e.printStackTrace();
}

setSize(700,450);
initTable();
loadAnalysisCombo();
//conn();
}
/*public static void main(String[] args) {
RMREntry RMREntry = new RMREntry();
RMREntry.setVisible(true);
RMREntry.setSize(720,390);
}*/
private void jbInit() throws Exception {
lblRawMaterialsID.setFont(new java.awt.Font("Dialog", 1, 12));
lblRawMaterialsID.setForeground(SystemColor.activeCaption);
lblRawMaterialsID.setText("Raw Material\'s ID :");
this.getContentPane().setLayout(xYLayout1);
pnl.setLayout(xYLayout2);
pnl.setLayout(xYLayout2);
txtRawMaterialsID.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(KeyEvent e) {
// txtRawMaterialsID_keyPressed(e);
}
});
/* txtStorageType.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(ActionEvent e) {
txtStorageType_actionPerformed(e);
}
});*/
txtCategory.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(ActionEvent e) {
txtCategory_actionPerformed(e);
}
});
txtStorageType.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(ActionEvent e) {
txtStorageType_actionPerformed(e);
}
});
this.getContentPane().add(pnl, new XYConstraints(180, 146, 492, 67));
pnl.add(spn, new XYConstraints(4, 0, 456, 64));
spn.getViewport().add(tblRequiredAnalysis, null);
lblRawmaterialsName.setFont(new java.awt.Font("Dialog", 1, 12));
lblRawmaterialsName.setForeground(SystemColor.activeCaption);
lblRawmaterialsName.setText("Raw Material\'s Name :");
lblCategory.setFont(new java.awt.Font("Dialog", 1, 12));
lblCategory.setForeground(SystemColor.activeCaption);
lblCategory.setText("Category :");
lblStorageType.setFont(new java.awt.Font("Dialog", 1, 12));
lblStorageType.setForeground(SystemColor.activeCaption);
lblStorageType.setText("Storage Type :");
lblRequiredAnalysis.setFont(new java.awt.Font("Dialog", 1, 12));
lblRequiredAnalysis.setForeground(SystemColor.activeCaption);
lblRequiredAnalysis.setText("Required Analysis :");
lblNote.setFont(new java.awt.Font("Dialog", 1, 12));
lblNote.setForeground(SystemColor.activeCaption);
lblNote.setText("Note :");
btnFind.setBackground(SystemColor.activeCaption);
btnFind.setFont(new java.awt.Font("Dialog", 1, 12));
btnFind.setForeground(Color.white);
btnFind.setText("Find");
btnAuto.setMnemonic(KeyEvent.VK_A);
btnCancel.setMnemonic(KeyEvent.VK_L);
btnClose.setMnemonic(KeyEvent.VK_C);
btnDelete.setMnemonic(KeyEvent.VK_D);
btnFind.setMnemonic(KeyEvent.VK_F);
btnSave.setMnemonic(KeyEvent.VK_V);
btnShow.setMnemonic(KeyEvent.VK_S);
btnUpdate.setMnemonic(KeyEvent.VK_U);

btnFind.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(ActionEvent e) {
btnFind_actionPerformed(e);
}
});
btnAuto.setBackground(SystemColor.activeCaption);
btnAuto.setFont(new java.awt.Font("Dialog", 1, 12));
btnAuto.setForeground(Color.white);
btnAuto.setText("Auto");
btnAuto.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(ActionEvent e) {
btnAuto_actionPerformed(e);
}
});
btnDelete.setBackground(SystemColor.activeCaption);
btnDelete.setFont(new java.awt.Font("Dialog", 1, 12));
btnDelete.setForeground(Color.white);
btnDelete.setText("Delete");
btnDelete.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(ActionEvent e) {
btnDelete_actionPerformed(e);
}
});
xYLayout1.setWidth(714);
xYLayout1.setHeight(399);
btnSave.setBackground(SystemColor.activeCaption);
btnSave.setFont(new java.awt.Font("Dialog", 1, 12));
btnSave.setForeground(Color.white);
btnSave.setText("Save");
btnSave.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(ActionEvent e) {
btnSave_actionPerformed(e);
}
});
btnUpdate.setBackground(SystemColor.activeCaption);
btnUpdate.setFont(new java.awt.Font("Dialog", 1, 12));
btnUpdate.setForeground(Color.white);
btnUpdate.setText("Update");
btnUpdate.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(ActionEvent e) {
btnUpdate_actionPerformed(e);
}
});
btnCancel.setBackground(SystemColor.activeCaption);
btnCancel.setFont(new java.awt.Font("Dialog", 1, 12));
btnCancel.setForeground(Color.white);
btnCancel.setText("Cancel");
btnCancel.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(ActionEvent e) {
btnCancel_actionPerformed(e);
}
});
btnShow.setBackground(SystemColor.activeCaption);
btnShow.setFont(new java.awt.Font("Dialog", 1, 12));
btnShow.setForeground(Color.white);
btnShow.setText("Show");
btnShow.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(ActionEvent e) {
btnShow_actionPerformed(e);
}
});
btnClose.setBackground(SystemColor.activeCaption);
btnClose.setFont(new java.awt.Font("Dialog", 1, 12));
btnClose.setForeground(Color.white);
btnClose.setText("Close");
btnClose.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(ActionEvent e) {
btnClose_actionPerformed(e);
}
});
this.getContentPane().add(lblRawmaterialsName, new XYConstraints(11, 42, -1, -1));
this.getContentPane().add(lblCategory, new XYConstraints(11, 68, -1, -1));
this.getContentPane().add(lblStorageType, new XYConstraints(11, 94, -1, -1));
this.getContentPane().add(lblRequiredAnalysis, new XYConstraints(11, 125, -1, -1));
this.getContentPane().add(lblNote, new XYConstraints(11, 240, -1, -1));
this.getContentPane().add(txtRawMaterialsID, new XYConstraints(153, 14, 83, -1));
this.getContentPane().add(txtCategory, new XYConstraints(153, 66, 147, -1));
this.getContentPane().add(txtRawMaterialsName, new XYConstraints(153, 40, 548, -1));
this.getContentPane().add(txtStorageType, new XYConstraints(153, 92, 147, -1));
this.getContentPane().add(btnFind, new XYConstraints(243, 14, -1, 21));
this.getContentPane().add(btnAuto, new XYConstraints(304, 14, -1, 21));
this.getContentPane().add(btnDelete, new XYConstraints(369, 14, -1, 21));
this.getContentPane().add(cmbCategory, new XYConstraints(305, 66, 396, 21));
this.getContentPane().add(cmbStorageType, new XYConstraints(305, 92, 396, 21));
this.getContentPane().add(txaNote, new XYConstraints(154, 240, 546, 72));
this.getContentPane().add(btnClose, new XYConstraints(633, 328, -1, 21));
this.getContentPane().add(btnShow, new XYConstraints(554, 328, -1, 21));
this.getContentPane().add(btnCancel, new XYConstraints(469, 328, -1, 21));
this.getContentPane().add(btnUpdate, new XYConstraints(382, 328, -1, 21));
this.getContentPane().add(btnSave, new XYConstraints(307, 328, -1, 21));
this.getContentPane().add(lblRawMaterialsID, new XYConstraints(11, 18, -1, -1));
this.getContentPane().add(pnl, new XYConstraints(155, 124, 549, 101));
connection();
addComboItemCat();
addComboItemSto();
}
// here is to add comboitem
public void addComboItemCat()
{
cmbCategory.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(ActionEvent e) {
cmbCategory_actionPerformed(e);
}
});
try{
Statement statement = con.createStatement();
String query = "select Catagory from TBL_FGINFO";
ResultSet rs = statement.executeQuery(query);
System.out.println("as ");
while(rs.next()){
cmbCategory.addItem(rs.getString(1));
System.out.println("asd ");
}
cmbCategory.setMaximumRowCount(3);
cmbCategory.setEditable(false);
}catch(SQLException ex){
System.out.println("User Caught Error: "+ex);
}

cmbCategory.addItemListener(
new ItemListener(){
public void itemStateChanged(ItemEvent e){
String string = (String)cmbCategory.getSelectedItem();
txtCategory.setText(string);
}
});
}
// here is to try
public void addComboItemSto()
{
cmbStorageType.setMaximumRowCount(3);
cmbStorageType.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(ActionEvent e) {
cmbStorageType_actionPerformed(e);
}
});
cmbStorageType.addItemListener(
new ItemListener(){
public void itemStateChanged(ItemEvent e){
String string = (String)cmbStorageType.getSelectedItem();
txtStorageType.setText(string);
}
});
}
//Method for Connection
public void connection(){
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
//Class.forName("oracle.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc racle:thin:@hirasql:1521:gcep","scott","tiger");
// DriverManager.getConnection("jdbc racle:thin:@Dc1:1521:gcep","scott","tiger");
// con=DriverManager.getConnection("jdbc dbc:gsestudent","anonymous","guest");

}catch(ClassNotFoundException ex){
JOptionPane.showMessageDialog(null,"Error :"+ex);
}catch(SQLException es){
JOptionPane.showMessageDialog(null,"Error while connecting to the database:"+es);
}
}

//find Action perform

void btnFind_actionPerformed(ActionEvent e) {
/*try{
Statement statement = con.createStatement();
rs=null;
rs = statement.executeQuery("SELECT * from tbl_rmiinfo_h where rmid ="+Integer.parseInt(txtRawMaterialsID.getText()));
if (rs.next()){
txtRawMaterialsName.setText(rs.getString(2));
txtCategory.setText(rs.getString(3));
txtStorageType.setText(rs.getString(4));
txaNote.setText(rs.getString(5));
JOptionPane.showMessageDialog(null,"find success ");
}
}
catch(SQLException ex){
JOptionPane.showMessageDialog(null,"Error : " + ex);
} */

getTableData();
}
//Action even of Auto Button
void btnAuto_actionPerformed(ActionEvent e) {
try{
Statement statement = con.createStatement();
String query = "select max(RMID) from tbl_rminfo_h";
ResultSet rs=statement.executeQuery(query);
int maxid=0;
if (rs.next()){
maxid =Integer.parseInt(rs.getString(1))+1;
}

txtRawMaterialsID.setText(""+maxid );
}
catch(SQLException ex){
JOptionPane.showMessageDialog(null,"Error : " + ex);
}
}
// Action event of delete Button
void btnDelete_actionPerformed(ActionEvent e) {
try{
Statement statement = con.createStatement();
String query = "DELETE from tbl_rminfo_h " + "where rmid = " + txtRawMaterialsID.getText()+ " ";
statement.executeQuery(query);
}
catch(SQLException ex){
JOptionPane.showMessageDialog(null,"Error : " + ex);
}
deleteTableData();
}
public void deleteTableData(){
try{
Statement statement = con.createStatement();
String query = "DELETE from tbl_rminfo_d " + "where rmid = " + txtRawMaterialsID.getText()+ " ";
statement.executeQuery(query);
}
catch(SQLException ex){
JOptionPane.showMessageDialog(null,"Error : " + ex);
}
JOptionPane.showMessageDialog(null,"Header and Detail Table Data successfully deleted ");
}//End of deleteTableData
void btnSave_actionPerformed(ActionEvent e) {
/*try{
Statement statement = con.createStatement();
String query = "insert into tbl_rmiinfo_h (" + "rmid, rmname, CATAGORY, storage, NOTE" +") VALUES (' " + txtRawMaterialsID.getText()+" ',' " + txtRawMaterialsName.getText() +" ',' " + txtStorageType.getText() +" ',' " + txtCategory.getText() +" ',' " + txaNote.getText() + " ')";
statement.executeUpdate(query);
}
catch(SQLException ex){
JOptionPane.showMessageDialog(null,"Error : " + ex);
}*/

setTableData();

}
//////////////////////// start of setTableData /////////////////////
public void setTableData(){
System.out.println("Prepstatement 100a");
getSwingFieldsData();
PreparedStatement prepStatement=null;
try{
prepStatement=con.prepareStatement("insert into tbl_rminfo_h values(?,?,?,?,?)");
System.out.println("Prepstatement 100");
prepStatement.setInt(1,Integer.parseInt(strRMID));
//System.out.println("Prepstatement 100a" +rs.getString(1));
prepStatement.setString(2,strRMName);
//System.out.println("Prepstatement 100b" +rs.getString(2));
prepStatement.setString(3,strCategory);
System.out.println("Prepstatement 101@");
prepStatement.setString(4,strStorageType);
prepStatement.setString(5,strNote);
System.out.println("Prepstatement 101");
prepStatement.execute();
System.out.println("Prepstatement 102");
prepStatement.clearParameters();
System.out.println("Prepstatement 103");
prepStatement.close();
System.out.println("Prepstatement 104");
JOptionPane.showMessageDialog(null,"Successfully Saved HeaderTable data");
/////////////////////Detail Table///////////////////////////

int numRows=tblRequiredAnalysis.getRowCount();
for(int i=0; i<numRows; i++){
PreparedStatement stmt = con.prepareStatement("INSERT INTO tbl_rminfo_d VALUES (?, ?, ?, ?)");
stmt.setInt(1, Integer.parseInt(strRMID));
if (Integer.parseInt(rowData[i][0].toString())>0)
stmt.setInt(2, Integer.parseInt(rowData[i][0].toString()));
//stmt.setInt(2, Integer.parseInt(rowData[i][1].toString()));
else break;
//donot store ananame
System.out.println("Prepstatement 1");
//stmt.setString(3, rowData[i][3].toString());
stmt.setString(3, rowData[i][2].toString());
System.out.println("Prepstatement 2");
//stmt.setString(4, rowData[i][4].toString());
stmt.setString(4, rowData[i][3].toString());
System.out.println("Prepstatement 2.1x");
stmt.execute();
System.out.println("Prepstatement 3");
stmt.clearParameters();
System.out.println("Prepstatement 4");
JOptionPane.showMessageDialog(null," Saved DetailTable data");
}

}
catch(SQLException e){
JOptionPane.showMessageDialog(null,"User caught"+e.getMessage());
}
catch(Exception e){
JOptionPane.showMessageDialog(null,"User caught"+e.getMessage()+"\nError !");
}
}
////////////////////// end of setTabledata //////////////////////
// Action event of Update button
void btnUpdate_actionPerformed(ActionEvent e) {
/*try{
Statement statement = con.createStatement();
String query = " UPDATE tbl_rmiinfo_h SET " + " rmname = ' " + txtRawMaterialsName.getText() + " ' where CATAGORY = " + txtCategory.getText()+ " ' where storage = " + txtStorageType.getText()+ " ' where NOTE = " + txaNote.getText()");
statement.executeQuery(query);
statement.close();
}
catch(SQLException ex){
JOptionPane.showMessageDialog(null,"Error : " + ex);
}*/
updateTableData();
}
/////////start of updateTableData//////////////

public void updateTableData(){
getSwingFieldsData();
PreparedStatement prepStatement=null;
PreparedStatement prepStatement2=null;
try{
prepStatement=con.prepareStatement("UPDATE tbl_rminfo_h SET rmname=?, category=?, storage=?, note=? where rmid=?");
prepStatement.setString(1,strRMName);
prepStatement.setString(2,strCategory);
prepStatement.setString(3,strStorageType);
prepStatement.setString(4,strNote);
prepStatement.setInt(5,Integer.parseInt(strRMID));
prepStatement.execute();
prepStatement.clearParameters();
prepStatement.close();
JOptionPane.showMessageDialog(null," Updated HeaderTable data");

/////////////////////// for jtableUpdate////////////////////

int numRows = tblRequiredAnalysis.getRowCount();
for(int i=0; i<numRows; i++){
// PreparedStatement stmt = con.prepareStatement("UPDATE tbl_rminfo_d SET rmid =?, anaid =?, expectedresult =?, comments =?");

PreparedStatement stmt = con.prepareStatement("UPDATE tbl_rminfo_d SET anaid=?, expectedresult=?, comments=? where rmid=?");
stmt.setInt(4, Integer.parseInt(strRMID));
// stmt.setInt(4, Integer.parseInt(rowData[i][0].toString()));//it is also ok
// stmt.setInt(1, Integer.parseInt(rowData[i][1].toString()));// it is also ok
if (Integer.parseInt(rowData[i][0].toString())>0)
stmt.setInt(1, Integer.parseInt(rowData[i][0].toString()));
//stmt.setInt(2, Integer.parseInt(rowData[i][1].toString()));
else break;
stmt.setString(2, rowData[i][2].toString());
stmt.setString(3, rowData[i][3].toString());
// stmt.setString(3, rowData[i][3].toString());
// stmt.setString(4, rowData[i][3].toString());
stmt.execute();
stmt.clearParameters();
stmt.close();
}
JOptionPane.showMessageDialog(null," Updated DetailTable data");
}
catch(SQLException e){
JOptionPane.showMessageDialog(null,"User caught"+e.getMessage());
}
catch(Exception e){
JOptionPane.showMessageDialog(null,"User caught"+e.getMessage()+"\nError !");
}

}

/////// end of update table data//////////////
//Action event of Cancel Button
void btnCancel_actionPerformed(ActionEvent e) {
/*txtRawMaterialsID.setText(" ");
txtRawMaterialsName.setText(" ");
txtStorageType.setText(" ");
txtCategory.setText(" ");
txaNote.setText(" ");*/

clearSwingFields();
}//JOptionPane.showMessageDialog(null," Updated DetailTable data"+stmt);

//Action event of Show Button
void btnShow_actionPerformed(ActionEvent e) {
try{

stmt = con.createStatement();
rs=stmt.executeQuery("select * from tbl_rminfo_h");
String str1="";
while(rs.next()){
str1 = str1 + "rmid : "+rs.getString(1)+" rmname : "+ rs.getString(2)+" CATEGORY : "+ rs.getString(3)+" storage : "+ rs.getString(4)+" NOTE : "+ rs.getString(5)+"\n";
}
JOptionPane.showMessageDialog(null,str1);

showTableData();
}
catch(Exception es){
JOptionPane.showMessageDialog(null,"Error while class not found:"+es);
}
}
/////////////// start of showTableData /////////////////////////////////////
public void showTableData(){
try{
stmt = con.createStatement();
rs=stmt.executeQuery("select * from tbl_rminfo_d");
String str2="";
while(rs.next()){
str2 = str2 + "RmID : "+rs.getString(1) + " AnaID : " + rs.getString(2)+ " Expected Result : " + rs.getString(3) + " Comments : " + rs.getString(4)+ "\n";
}
JOptionPane.showMessageDialog(null, str2);
}
catch(Exception es){
JOptionPane.showMessageDialog(null,"Error while class not found:"+ es);
}

}//end of showTableData

///////////////// End of showTableData ///////////////////////////////////
//Action event of Close Button
void btnClose_actionPerformed(ActionEvent e) {
dispose();
}
public void getTableData(){
boolean isDataFound = false;
Statement stmt = null;
ResultSet rs = null;
int iRMID = Integer.parseInt(txtRawMaterialsID.getText().trim());
try{
//"SELECT * from tbl_rmiinfo_h where rmid ="+Integer.parseInt(txtRawMaterialsID.getText()
String strSQL = "Select * from tbl_RMINFO_h where rmid = " + iRMID ;
stmt = con.createStatement();
rs = stmt.executeQuery(strSQL);
System.out.println("Line 4" + strSQL);

if (rs.next()){
/* txtRawMaterialsName.setText(rs.getString(2));
txtCategory.setText(rs.getString(3));
txtStorageType.setText(rs.getString(4));
txaNote.setText(rs.getString(5));
System.out.println("Line 6" + rs.getString(5));
}*/
isDataFound = true;
txtRawMaterialsID.setText("" + rs.getInt(1));
System.out.println("RM NAME" + rs.getString(2));
txtRawMaterialsName.setText(rs.getString(2));
txtCategory.setText(rs.getString(3));
txtStorageType.setText(rs.getString(4));
txaNote.setText(rs.getString(5));
System.out.println("Line 6" + rs.getString(5));
//JOptionPane.showMessageDialog(this,"Data Found");
}
else{
System.out.println("Data Not Found");
JOptionPane.showMessageDialog(this,"Data Not Found\n Try With Another One");
isDataFound = false;
}

}
catch(SQLException e){
System.out.print("User caught 1 " + e);
}
catch(Exception e){
System.out.print("User caught 2 " + e);
}
////////// find for DetailTable ///////////////////////

Statement stmt2 = null;
ResultSet rs2 = null;
try{
// String strSQLforTable = "Select * from tbl_RMINFO_d where rmid = " + iRMID ;
//String strSQLforTable = "select * from tbl_rminfo_d where tbl_rminfo_d.rmid="+iRMID+" and tbl_rminfo_d.anaid = tbl_analysis.anaid";
String strSQLforTable = "select tbl_rminfo_d.anaid, tbl_analysis.ananame,tbl_rminfo_d.expectedresult,tbl_rminfo_d.comments from tbl_analysis ,tbl_rminfo_d where tbl_rminfo_d.rmid=" +iRMID+ " and tbl_rminfo_d.anaid = tbl_analysis.anaid";
stmt2 = con.createStatement();
rs2 = stmt2.executeQuery(strSQLforTable);
int i = 0;
NRows = 0;////
while(rs2.next()){
if(!isDataFound) break;
// System.out.println("Line 12 NRows = " + NRows + " id = " + rs2.getInt(1));
rowData[NRows][0] = new Integer(rs2.getInt(1));
//System.out.println("Line 13" + rs.getString(5));
//rowData[NRows][1] = rs2.getString(2);
//rowData[NRows][1] =new Integer(rs2.getInt(2));
//ystem.out.println("Line 14" + rs.getString(2));
rowData[NRows][1] = rs2.getString(2);
System.out.println("Line 15" + rs.getString(3));
rowData[NRows][2] = rs2.getString(3);
rowData[NRows][3] = rs2.getString(4);
i++;
myModel.fireTableDataChanged();
NRows++;
}
}
catch(SQLException e){
System.out.print("User caught 2" + e);
}
catch(Exception e){
System.out.print("User caught 3" + e);
}
/////////////////////////////////////////////////
System.out.println("Line 12 NRows = " + NRows);
if(!isDataFound) {
clearSwingFields();
}
}

private void getSwingFieldsData(){
strRMID = txtRawMaterialsID.getText();
strRMName = txtRawMaterialsName.getText();
strCategory = txtCategory.getText();
strStorageType = txtStorageType.getText();
strNote = txaNote.getText();
}

private void clearSwingFields(){
txtRawMaterialsID.setText("");
txtRawMaterialsName.setText("");
txtCategory.setText("");
txtStorageType.setText("");
txaNote.setText("");

NRows = 1;
System.out.println("Line 1xx NRows = " + NRows );
rowData[0][0] = new Integer(0);
rowData[0][1] = "";
rowData[0][2] = "";
rowData[0][3] = "";
myModel.fireTableDataChanged();
}

/* void showId(String value,int row){
//System.out.println("Place 1");
String sql="SELECT anaid,anaName FROM tbl_analysis WHERE (anaName='"+value.toString()+"')";
try{
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(sql);
if (rs.next()){
rowData[row][0]=new Integer(rs.getInt(1));
rowData[row][2]="";
rowData[row][3]="";
myModel.fireTableCellUpdated(row,0);
}
rs.close();
stmt.close();
}
catch(SQLException sqlex){
sqlex.printStackTrace();
System.out.print(sqlex.getMessage()); // ??
}
}*/

public void initTable() {
myModel = new MyTableModel();
tblRequiredAnalysis.setModel(myModel);
//set the preferred column width
TableColumn column = null;
for (int i = 0; i < 4; i++) {
column = tblRequiredAnalysis.getColumnModel().getColumn(i);
switch (i){
case 0: column.setPreferredWidth(80); break;
case 1: column.setPreferredWidth(100); break;
case 2: column.setPreferredWidth(150); break;
case 3: column.setPreferredWidth(100); break;
case 4: column.setPreferredWidth(100); break;
default: column.setPreferredWidth(120); break;
}
}
}
/////////////////////// Start of loadAnalysisCombo ////////////////////////////
public void loadAnalysisCombo(){
JComboBox cmb= new JComboBox();
cmb.setEditable(true);
TableColumn idColumn = tblRequiredAnalysis.getColumnModel().getColumn(0);
idColumn.setCellEditor(new DefaultCellEditor(cmb));
// DefaultTableCellRenderer idCellRenderer = new DefaultTableCellRenderer();
// idColumn.setCellRenderer(idCellRenderer);

try{
Statement statement = con.createStatement();
// String sqlID = "SELECT VENID FROM TBL_VENDOR";
// String sqlID = "SELECT DISTID FROM TBL_DISTRIBUTOR";
String sqlID = "SELECT anaid,ananame FROM tbl_analysis";
// String sqlID = "SELECT fgid FROM tbl_fginfo";

rs= statement.executeQuery(sqlID);
// int i=0;
while (rs.next()){
// Int sqlId = rs.getInt(1);
// sqlId = rs.getString(1);
//String Ids[i]=rs.getString(1);
//cmb.getItemAt(i+1);
//cmb.addItem(rs.getString(2));
//i++;
////////////////////////////////

cmb.addItem(rs.getString(1));
}
}
catch(SQLException ex)
{
;
}
catch(Exception e)
{
;
}
}
//////////////////////// End of loadAnalysisCombo ///////////////////////////////////////

class MyTableModel extends AbstractTableModel {
String[] columnNames = {"Analysis ID","Analysis Name","Expected Result","Comments"}; //&&&&&
//String[] columnNames = {"RM ID","Ana ID", "Expected Result","Comments"}; //&&&&&
public int getColumnCount() {
return columnNames.length;
}
public int getRowCount() {
return 2;
}
public String getColumnName(int col) {
return columnNames[col];
}
public Object getValueAt(int row, int col) {
return rowData[row][col];
}
public Class getColumnClass(int c) {
if(c==0) return Integer.class; //&&&&&&&
//if(c==1) return Integer.class;
if(c==1) return String.class;
if(c==2) return String.class;
if(c==3) return String.class;
return null;
}

public boolean isCellEditable(int row, int col) {
return true;
}
public void setValueAt(Object value, int row, int col) {
if (col==0){
if(!value.toString().equalsIgnoreCase("")){
String sql="SELECT anaid, anaName FROM tbl_analysis WHERE anaId="+Integer.parseInt(value.toString());
// String sql="SELECT * from FROM tbl_rminfo_d WHERE anaId="+Integer.parseInt(value.toString());
// String sql= "INSERT INTO tbl_rminfo_d VALUES"
try{
Statement stmt =con.createStatement();
ResultSet rs=stmt.executeQuery(sql);
if(rs.next()){
rowData[row][0]=new Integer(rs.getInt(1));
// rowData[row][1]=new Integer(rs.getInt(2));
rowData[row][1]=new String(rs.getString(2));
// rowData[row][2]= new String(rs.getString(3)); //"";
// rowData[row][3]= new String(rs.getString(4)); //"";
// myModel.fireTableDataChanged();
}else{
JOptionPane.showMessageDialog(null,"Sorry, Invalid Analysis Id is entered");
}
rs.close();
stmt.close();
}
catch(SQLException sqlex){
sqlex.printStackTrace();
System.out.println( "" + sqlex);
}
}

rowData[row][0]=value;
System.out.println("Can not execute the query");
}
if(col==1){
rowData[row][1]=value;
// showId(value.toString(), row);
// to load unit of measure combo
}
if(col==2){
rowData[row][2]=value;
}
if(col==3 ){//col 4 contains qty
rowData[row][col]=value;
//rowData[row][3]=value;
//int r=tblRequiredAnalysis.getSelectedRow();
// int nr=tblRequiredAnalysis.getRowCount()-1;
}
}

}
void cmbStorageType_actionPerformed(ActionEvent e) {
}
void txtCategory_actionPerformed(ActionEvent e) {
}
void txtStorageType_actionPerformed(ActionEvent e) {
}
void cmbCategory_actionPerformed(ActionEvent e) {
}
}
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic