MarekMatias icon

DataBase

MarekMatias | PRO | 03/30/17 10:47:59 AM UTC | 0 ⭐ | 7120 👁️ | Never ⏰ | []
PostgreSQL |

1.42 KB

|

None

|

0 👍

/

0 👎

import java.sql.*;
import java.util.logging.*;
 
// java -cp postgresql-9.4-1201.jdbc4.jar:. DBtest
 
public class DatabaseProject {
    
    public static void main(String[] args) {
            
           
        String url = "jdbc:postgresql://localhost:5432/<TheStore>";
        String user = "<postgres>";
        String password = "<123456789>";
        Connection con = null;
 
        //CONNECTING
        try {
            con = DriverManager.getConnection(url, user, password);
 
        } catch (SQLException ex) {
                Logger lgr = Logger.getLogger(DBtest.class.getName());
                lgr.log(Level.WARNING, ex.getMessage(), ex);
 
        }
 
        testDB(con);
    }
 
    public static void testDB(Connection con){
        //RUN AN EXAMPLE QUERY
        try {
            Statement st = con.createStatement();
                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";
                ResultSet rs = st.executeQuery(query);
                while (rs.next()) {
                        String answer = rs.getString("answer");
                        System.out.printf("The answer is %s!\n", answer);
                }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

Comments

  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    👍

    /

    👎