Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=NitgenAccessManager;user=Perm;password=^&8&^%8*Pe$!");.
Statement statement = con.createStatement() ;.
ResultSet resultset = statement.executeQuery("select Top 10 * from NGAC_AUTHLOG") ;.
Resultset.next();.
________________.
PostgreSQL.
Try {.
String driver = "org.postgresql.Driver";.
String url = "jdbc:postgresql://localhost:5432/cpanelusername_dbname";.
String username = "<Username>";String String password = "<Password>";String myDataField = null;.
String myQuery = "SELECT * FROM sample LIMIT 1";.
Connection myConnection = null;.
PreparedStatement myPreparedStatement = null;.
ResultSet myResultSet = null;.
Class.forName(driver).newInstance();.
MyConnection = DriverManager.getConnection(url,username,password);.
MyPreparedStatement = myConnection.prepareStatement(myQuery);.
MyResultSet = myPreparedStatement.executeQuery();.
If(myResultSet.next()).
MyDataField = myResultSet.getString("dispname");.
Out.print(myDataField);.
}.
Catch(ClassNotFoundException e){e.printStackTrace();}.
Catch (SQLException ex).
{.
out.print("SQLException. "+ex.getMessage());.
out.print("SQLState. " + ex.getSQLState());.
out.print("VendorError. " + ex.getErrorCode());.
}.
