cannnot check customer ID in my database..

CodeCharge Studio

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> Java

cannnot check customer ID in my database..

Author

Message

liee

Posts: 1

Posted: 10/19/2012, 9:25 PM

try{
stmt=con.createStatement();
String query="Select * FROM customer WHERE idno=('"+idnum+"')";
ResultSet rs=stmt.executeQuery(query);
if(rs.next())
{
String dbpass=rs.getString(idnum);
if(dbpass.equals(""))
{
JOptionPane.showMessageDialog(this, "you are members", "Success", JOptionPane.INFORMATION_MESSAGE);

}
else
{
JOptionPane.showMessageDialog(this, "you are not member", "Success", JOptionPane.QUESTION_MESSAGE);

}
}
}

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home | Search | Members | Register | Login