Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.SQLException;
- public class Main1 {
- private static final String QUERY1 = "CREATE TABLE 'users' ( `id` INT NOT NULL , `first_name` VARCHAR(60) NOT NULL , `last_name` VARCHAR(60) NOT NULL , `email` VARCHAR(60) NOT NULL , 'salary' REAL(7,2) NOT NULL, 'sex' INT NOT NULL)";
- private static final String QUERY2 = "CREATE TABLE 'departments' ( `id` INT NOT NULL , `name` VARCHAR(60) NOT NULL )";
- private static final String QUERY3 = "CREATE TABLE 'departments' ( `id` INT NOT NULL , `name` VARCHAR(255) NOT NULL )";
- private static final String QUERY4 = "SELECT AVG(salary) FROM users";
- private static final String QUERY5 = "SELECT MAX(salary) FROM users WHERE id = 2";
- private static final String QUERY6 = "SELECT * FROM users WHERE salary > 5000";
- public static void main(String[] args) {
- try (Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/exam2poprawa?useSSL=false", "root", "coderslab")) {
- PreparedStatement ps = con.prepareStatement(QUERY1);
- ps.executeUpdate();
- ps = con.prepareStatement(QUERY2);
- ps.executeUpdate();
- ps = con.prepareStatement(QUERY3);
- ps.executeUpdate();
- ps = con.prepareStatement(QUERY4);
- ps.executeUpdate();
- ps = con.prepareStatement(QUERY5);
- ps.executeUpdate();
- ps = con.prepareStatement(QUERY6);
- ps.executeUpdate();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement