Ms Access sql problem

Expand Post »

hi everyone

-In the code below, the line marked by *** is where i read my text field.
-The value of the text field is stored into a variable "InputUserName ".
-My question is: What do i put in the place of @@@@@ so as to have the same variable "InputUserName " referenced.
- I want to search/query my db by whatever the user enters as his username.
i'm on jdk1.5.0

Thanx in advance

Java Syntax (Toggle Plain Text)
Driver d = (Driver)Class.forName"sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
String URL = "jdbc:odbc:" + "CMSC446"; 
con = DriverManager.getConnection( URL ,"",""); 
statement   = con.createStatement();
*** InputUserName = username.getText();	//reading the Text field
result = statement.executeQuery("SELECT password FROM terry 
WHERE username =@@@@@");
 
while(result.next())
{
    InputPassword = Inpassword.getText();      //reading password field
 
    String dbPassword = result.getString("password"); //obtaining db password
 
    if (dbPassword.equals(InputPassword))
    {			
       //aknowledge
    }
    else
   {
 
   }
}
Driver d = (Driver)Class.forName"sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
String URL = "jdbc:odbc:" + "CMSC446"; 
con = DriverManager.getConnection( URL ,"",""); 
statement   = con.createStatement();
*** InputUserName = username.getText();	//reading the Text field
result = statement.executeQuery("SELECT password FROM terry 
WHERE username =@@@@@");

while(result.next())
{
    InputPassword = Inpassword.getText();      //reading password field
    							
    String dbPassword = result.getString("password"); //obtaining db password

    if (dbPassword.equals(InputPassword))
    {			
       //aknowledge
    }
    else
   {
        
   }
}

Similar Threads

convert MS Access to MS SQL Server in VB.NET
Difference between ms access and sql in Visual Basic 4 / 5 / 6
Weird ASP/SQL Problem in ASP
QUICK! Access SQL using ASP and javascript in ASP
Problem with URL access to SQL Server 2000 db in RSS, Web Services and SOAP

teritori

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

11 posts
since Jun 2004

Permalink

Aug 12th, 2004

Re: Ms Access sql problem

>>result = statement.executeQuery("SELECT password FROM terry
WHERE username =@@@@@");

just put it right in ;-)

Java Syntax (Toggle Plain Text)
result = statement.executeQuery("SELECT password FROM terry 
WHERE username ="+InputUserName);
result = statement.executeQuery("SELECT password FROM terry 
WHERE username ="+InputUserName);

Just realise that executeQuery just takes in a String and you may compose Strings however way you want.
If InputUserName="cosi", then

"SELECT password FROM terry WHERE username="+InputUserName
equals
"SELECT password FROM terry WHERE username=cosi"

Only think you have to watch out for is you must encode your strings if you expect nonalphanumeric symbols. URLEncoder/URLDecoder is a cheap way to go about it...

An alternative strategy is to use PreparedStatements. (See http://java.sun.com/j2se/1.4.2/docs/...Statement.html)

Java Syntax (Toggle Plain Text)
   PreparedStatement pstmt = con.prepareStatement("UPDATE EMPLOYEES
                                     SET SALARY = ? WHERE ID = ?");
   pstmt.setBigDecimal(1, 153833.00)
   pstmt.setInt(2, 110592)
   PreparedStatement pstmt = con.prepareStatement("UPDATE EMPLOYEES
                                     SET SALARY = ? WHERE ID = ?");
   pstmt.setBigDecimal(1, 153833.00)
   pstmt.setInt(2, 110592)

Hope this helps!

Ed

cosi

Reputation Points: 17

Solved Threads: 1

Junior Poster

Offline

153 posts
since Aug 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Java Forum Timeline: Help for my project

Next Thread in Java Forum Timeline: I need to re-write this code using a 'while' loop.

DaniWeb Message

Cancel Changes

User Name
Password