How to Connect to DB?
import java.sql.Connection;
import java.sql.DriverManager;
/**
* This Class returns a Connection Object
*
*/
public class GetDBConnection
{
public GetDBConnection(){} //constructor
public java.sql.Connection getConnection()
{
Connection conn = null;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:XE", "ganesh", "ganesh");
System.out.println("Successfully Connected to DB");
} catch (Exception e)
{
System.out.println("Exception Caught while Connecting to DB " + e.getMessage());
e.printStackTrace();
}
return conn;
}
}
############
import GetDBConnection;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
//Use the Connection object and make a connection to the db
//to check the credentials
public class ValidateUser
{
public boolean checkUser(String name, String pswd)
{
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try
{
conn = new GetDBConnection().getConnection();
ps = conn.prepareStatement("select password from PraanaUsers where username = ?");
ps.setString(1, name);
System.out.println("Executing SQLQUERY");
rs = ps.executeQuery();
System.out.println("SUCCESSFULLY EXECUTED RS");
String temp = null;
while (rs.next())
{
temp = rs.getString(1);
}
if (pswd.equals(temp))
{
System.out.println("User Exists...Validation Successful");
return true;
} else
{
System.out.println("User Does Not Exist...Validation Failed");
return false;
}
} catch (Exception e)
{
e.printStackTrace();
} finally
{
try {
if (rs != null) {
rs.close();
}
if (ps != null) {
ps.close();
}
if (conn != null) {
conn.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
return false;
}
Ganesh Babu N R
0 comments:
Post a Comment