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
0 B
|👍
/👎