Advertisement
MarekMatias

DataBase

Mar 30th, 2017
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. import java.sql.*;
  2. import java.util.logging.*;
  3.  
  4. // java -cp postgresql-9.4-1201.jdbc4.jar:. DBtest
  5.  
  6. public class DatabaseProject {
  7.    
  8.     public static void main(String[] args) {
  9.            
  10.            
  11.         String url = "jdbc:postgresql://localhost:5432/<TheStore>";
  12.         String user = "<postgres>";
  13.         String password = "<123456789>";
  14.         Connection con = null;
  15.  
  16.         //CONNECTING
  17.         try {
  18.             con = DriverManager.getConnection(url, user, password);
  19.  
  20.         } catch (SQLException ex) {
  21.                 Logger lgr = Logger.getLogger(DBtest.class.getName());
  22.                 lgr.log(Level.WARNING, ex.getMessage(), ex);
  23.  
  24.         }
  25.  
  26.         testDB(con);
  27.     }
  28.  
  29.     public static void testDB(Connection con){
  30.         //RUN AN EXAMPLE QUERY
  31.         try {
  32.             Statement st = con.createStatement();
  33.                 String query = "select ram (exp(sin(23)*sin(23)+cos(23)*cos(23))*pi()*(exp(sin(23)*sin(23)+cos(23)*cos(23)+sin(23)*sin(23)+cos(23)*cos(23))+cos(pi()/(sin(23)*sin(23)+cos(23)*cos(23)+sin(23)*sin(23)+cos(23)*cos(23))))*(sin(23)*sin(23)+cos(23)*cos(23)+sin(23)*sin(23)+cos(23)*cos(23))/(sin(23)*sin(23)+cos(23)*cos(23)+sin(23)*sin(23)+cos(23)*cos(23)+sin(23)*sin(23)+cos(23)*cos(23)) as int) as answer";
  34.                 ResultSet rs = st.executeQuery(query);
  35.                 while (rs.next()) {
  36.                         String answer = rs.getString("answer");
  37.                         System.out.printf("The answer is %s!\n", answer);
  38.                 }
  39.         } catch (SQLException e) {
  40.             e.printStackTrace();
  41.         }
  42.     }
  43. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement