omar salem

Thank you Paul. The thing is that I had no Idea of such features in java otherwise I wouldn't have posted my Query. However, the hints you dropped are valuable. Thanks again

Thank you but how %s differs from $1?...I mean is that a format that could be easily replaced? and I don't have to use the conventions I mentioned. I just put them as examples and I wanted to know how could any part of a given string be replaced during whatever execution?

Hey ranchers,
I am new to java and I have this query:
Lets say I have the following string : String s = " Dear $1
This is to inform you that $2 is being postponed to $3"

Now simply $1, $2, $3 have to be replaced by some database fields during sending of this message to recipients.
the question is how would my string object s process this string and replace $1,$2,$3 with the appropriate fields from the database? Any clue how to do this?

Dear Ranchers,

I am developing a simple JDBC application simulating the four basic operations performed on a database. The insert,delete, and retrieve operations are working fine but for the update operation the executeUpdate() method is executed but no effects reflect on the database.The database on which the application is developed is MS-Access. Here is the code i am using :

if(ae.getSource()==b6) { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc:odbc:information"); String sql="UPDATE data SET name=?, date_of_a=?,six=?,age=?,date_of_z=?, no_tel=?,notes =? WHERE id_number=?"; System.out.println("Mabrook"); PreparedStatement ps = con.prepareStatement(sql); System.out.println("Mabrook"); ps.setInt(1,Integer.parseInt(t1.getText())); ps.setString(2,t2.getText()); ps.setString(3,t3.getText()); ps.setString(4,t4.getText()); ps.setString(5,t5.getText()); ps.setString(6,t6.getText()); ps.setString(7,t7.getText()); ps.setString(8,t8.getText()); ps.executeUpdate(); System.out.println("Mabrook11"); con.commit(); con.close(); } catch(Exception e) { System.out.println(e); e.printStackTrace(); } }

I would appreciate your help thanking you in advance.

Thanks alot for the fast reply.

Hi Ranchers,
Whats the event that i can use if i want to show button name when that button get focus ( Only Selected but NOT Entered ) or when i move the mousre over it?

Thanks in advance.
Omar Salem

Thanks for your help.......I really got it to work now...Thanks again
Omar Salem

Thanks Bear....Never known about code tags before

Hi Ranchers,

I am trying to validate a user name and a password by comparing details in the database with those provided by the user inside the text fields of the simple frame created for this test. the condition gets always true even if the entries do not match details from the database and always gives me the message "Match Found". Here is the code i worte for this :
public void actionPerformed(ActionEvent ae) { if(ae.getSource()==enter) { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con = DriverManager.getConnection("jdbc:odbc:omar"); System.out.println("OK GOOD"); Statement st = con.createStatement(); ResultSet rs = st.executeQuery("select * from details"); while(rs.next()) { if(rs.getString(1).equals(user.getText()) && rs.getString(2).equals(pass.getText())); { JOptionPane.showMessageDialog(null,"Match Found"); } else { JOptionPane.showMessageDialog(null,"Illegal Access"); } } } catch(Exception e) { } }

I would appreciate your help and fast response.
Omar Salem

Hi Ranchers,

I have built a small GUI application using Swing that has one text field and three buttons named first,next,and last respictevely. Using these buttons i want to traverse through the ResultSet object.
when i click on the 'first button' it works fine and retrives the first record from the database.
This is the logic i applied for the 'first' button :
if(ae.getSource()==first)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:omah");
query = " select * from data1";
st = con.createStatement();
rs = st.executeQuery(query);
while(rs.next())
{
if(rs.getRow()==1)
//System.out.println(rs.getString(1));
t.setText(rs.getString(1));
else
{
while(rs.last())
{
t.setText(rs.getString(1));
}
}

}
}
catch(Exception e)
{
System.out.println(e);
}

now for the 'next' button which will fetch the next record in the database i have read the current cursor position using getRow() method then i increased it by 1 so that the cursor moves to the next record and fetch it then display its value in the text field. Here is the code i applied for this :
if(ae.getSource()==next)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:omah");
query = " select * from data1";
System.out.println("Hi");
System.out.println("Hi");
st = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = st.executeQuery(query);
System.out.println("Hi");
int i = rs.getRow();
i = i+1;
System.out.println("Hi");
boolean b = rs.absolute(i);
t.setText(rs.getString(1));

}

catch(Exception e)
{
System.out.println(e);
}
}
i was trying to use the absolute() method but couldnt actually get to the next record. All i need is some help in traversing for first, next, end ad so on.

Regards
Omar Salem

Thank you all. That really helped....I really appreciate it.
Omar Salem

Thanks for you both......I already know that there is a Math.sqrt() method but that would calculate the square root for me. what i am trying to do is to make my program calculate the square root without using any built in methods.

Thanks again
Omar Salem

Hi Ranchers

I am trying to make a java program that calculates the square root of a given number. I used a mathematical formula to generate the square root called Bakhshali approximation. It states that if (N square) is the nearest perfect square to the number S. S is the number we are finding the square root for then the square root of S is calculated as follows:
1- D = S-(N square)
2- P = D/2N
3- A = N + P
4- then square root of S is approximately given by A - (p square)/2A

now in my program i have written the above calculations but the problem i am facing now is how to make my program selects the nearest perfect square.

i have tried to take a while loop to find the squares of the numbers less than or equal to the value of S. then comparing these squares one by one with S until i get the nearest square.

while( i <= S ) { int a = i * i; // to find squares i++; if(a<=S) { NSQUARE = a; // this is the value of NSQUARE int N = i; } } // now start doing the calculations D = S - NSQUARE; P = D/2*N; A = N + P; sqr = A - (p*p)/2*A System.out.println("Square root is "+" "+sqr); // end of code

i know it my code has a lot of errors but would any one suggest something.
I would appreciate your help.

Omar Salem
[edit]Add code tags. CR[/edit]
[ December 04, 2008: Message edited by: Campbell Ritchie ]

Hi everyone
I am new to jdbc programming. I am trying to design a jdbc application through wich user will be able to pass table name and table structure during run time. My program would ask the user to pass table name and table fields through the console then it would create the specified table at the target database. I have tried the PreparedStatement interface but could not actually get to the method that would serve the purpose.

I have tried this code :

public void tableCreation()
{
BufferedReader br = new BufferedReader(new(InputStreamReader(System.in)));
System.out.println("Enter Table's Name:");
String tablename = br.readLine();
System.out.println("Enter filed name :");
String field1 = br.readLine();
System.out.println("Enter Filed Size");
int i = Integer.parseInt(br.readLine());

// and so on for the remaining fields.
//Can i use PreparedStatement object for that?
// How would my query to the database look like?

PreparedStatement pst = con.createStatement();
pst.execute(query);
}

Would highly appreciate your help.

Omar Salem

We are two different people...but brothers