aspose file tools*
The moose likes JDBC and the fly likes jdbc odbc issue? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "jdbc odbc issue?" Watch "jdbc odbc issue?" New topic
Author

jdbc odbc issue?

Devendra Ghag
Greenhorn

Joined: Jun 19, 2013
Posts: 14
what is the wrong in these code?
code successfully run but record is not deleted from database
my database is ms access 2007
database columns are as follow
Building_no Customer_Name
but record is not deleted
here is the code


please correct me if i was wrong or tell me suggestion what to do?





thanks in advanced for the help...
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18659
    
    8

The code asks the database to delete all records where the Building_No code contains the string "Building_No". Presumably there aren't any such records.

But presumably that isn't what you wanted. I expect you want to get some value from the GUI and use that instead of the string "Building_No".
Devendra Ghag
Greenhorn

Joined: Jun 19, 2013
Posts: 14
thanks man...
but i have one more query related to these

a customer having multiple news paper in his account, if i want to delete particular paper from customer
how to do.
here is the code but i finding difficulty to use it


import java.awt.Container;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.swing.*;

public abstract class delete_paper extends JFrame implements ActionListener
{
JTextField textFieldId;
JLabel l1;
JLabel l3;
JLabel l5;
JLabel l6;
JComboBox combo;
String paper[] = {"Navakal","SandhyaKal","Pudhari","MidDay","Inqlab","BusinessLine","Mumbai Samachar","GujrajSamachar","KarnatakMalla","Vartahar","PunyaNagari"};
JButton b2;
Container c = getContentPane();
delete_paper()
{
super("Shree DattaDigambar Samarth");
setBounds(140,250,777,555);
c.setLayout(null);
textFieldId = new JTextField();
l1 = new JLabel("New Customer Entry");
l3 = new JLabel("Customer Name");
l5 = new JLabel("Paper");
combo = new JComboBox(paper);
l1.setBounds(10,10,340,20);
l3.setBounds(110,20,140,70);
l5.setBounds(400,50,140,20);
textFieldId.setBounds(10,70,70,20);
combo.setBounds(400,70,130,20);
b2 = new JButton("Ok");
b2.setBounds(10,160,50,20);
c.add(combo);
c.add(b2);
c.add(l1);
c.add(l3);
c.add(l5);
c.add(textFieldId);
setVisible(true);
setDefaultCloseOperation(EXIT_ON_CLOSE);
b2.addActionListener(this);
}
public static void main(String[] args)
{
delete_paper ap=new delete_paper() {};
}
public void actionPerformed(ActionEvent e)
{

System.out.println("You clicked the button");
if(e.getSource()==b2)
{
try
{
Connection con;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbcdbc:devendra");
try
{

java.sql.Statement st = con.createStatement();
PreparedStatement ps = con.prepareStatement("DELETE from Customer WHERE Customer_Id = ? and Paper_Name = ? ");
ps.setString(1,textFieldId.getText());
ps.setString(4,combo.getSelectedItem().toString());
ps.executeUpdate();
JOptionPane.showMessageDialog(null,"You successfully Enter the Entry");
}
catch (SQLException s)
{
System.out.println("SQL code does not execute.");
JOptionPane.showMessageDialog(null,"Please Enter the Detail Correctly");
}
}
catch (ClassNotFoundException | SQLException ee)
{
System.out.println("Error:connection not created");
JOptionPane.showMessageDialog(null,"Please Enter the Detail Correctly");
}
}
}
}


thanks in advanced for the help??
 
 
subject: jdbc odbc issue?