Hi,
There is slight problem in your code.
Check The lines before
System.exit(1);
logically it self imperative that you don't have to
write code after exit statement.
Improve your coding style.
From : Paresh
*** Java is the latest BUZZWORD ***
[EMAIL PROTECTED]
MJS MJS wrote:
Hi everyone,Thanks
to Yogesh and Stephen Raj Arokiasamy for the quick response but the problem
still persists.I am using a system dsn called mjs.At
compile time there r no errors only 1 warning but as soon as I run this
code it hangs.I agree that I have not added a window listener nut the system.exit(1)
sould at least allow me to exit.Please
do help,Thanks in advance,MJSimport
java.sql.*;
import java.awt.*;
import java.awt.event.*;
import java.util.*;
import sun.jdbc.odbc.JdbcOdbcDriver; public
class nayausr extends Frame implements ActionListener
{
String temp,temp1,temp2;
static Connection con;
public static void main(String s[])
{
nayausr t=new nayausr();
t.setLayout(new FlowLayout());
t.setSize(500,500);
t.create(t);
} public
void create(nayausr f)
{
Label lbel=new Label("Please enter
new user details");
Label lb=new Label("
");
Label l1=new Label("Username
: ");
TextField t1=new TextField(20);
Label l2=new Label("
Password : ");
TextField t2=new TextField(20);
Label l3=new Label("
Employee number : ");
TextField t3=new TextField(20);
t2.setEchoCharacter('*');
Label lb1=new Label("
"); Button b=new Button();
b.setLabel("SUBMIT");
b.addActionListener(f);
f.add(lbel);
f.add(l1);
f.add(t1);
f.add(lb);
f.add(l2);
f.add(t2);
f.add(lb1);
f.add(l3);
f.add(t3); f.add(b);
temp =t1.getText();
temp1 =t3.getText(); f.setVisible(true);
} public
void actionPerformed(ActionEvent e)
{
String s=e.getActionCommand();
if (s.equals("SUBMIT"))
{
Db(temp,temp1);
}
} public
void Db(String te1,String te2)
{
String url="jdbc:odbc:mjs";
try
{
try
{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch (Exception e){}
con=DriverManager.getConnection(url,"",""); Statement
s1=con.createStatement(); String
qq="INSERT INTO abc VALUES('"+"'"+te1+"','" +te2+"' )";
s1.executeUpdate(qq);
System.exit(1);
System.out.println("INSERTED SUCCESSFULLY
" ); s1.close();
con.close();
} catch(SQLException
e)
{ }
finally
{
try {con.close();
}
catch (Exception w){}
} } }
|
