Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- class connection{
- private String server = MyDBInfo.MYSQL_DATABASE_SERVER;
- private String username = MyDBInfo.MYSQL_USERNAME;
- private String password = MyDBInfo.MYSQL_PASSWORD;
- private String database = MyDBInfo.MYSQL_DATABASE_NAME;
- private Connection con;
- private ResultSet rs;
- private Statement statement;
- public void call() {
- try {
- Class.forName("com.mysql.jdbc.Driver");
- con = DriverManager.getConnection("jdbc:mysql://" + server, username, password);
- Statement stmt = (Statement) con.createStatement();
- stmt.executeQuery("USE " + database);
- } catch (SQLException e) {
- System.out.println("fuck me");
- e.printStackTrace();
- } catch (ClassNotFoundException e) {
- System.out.println("fuck me now");
- e.printStackTrace();
- }
- }
- public void sendStatement(String statementString) {
- try {
- statement = (Statement) con.createStatement();
- rs = statement.executeQuery(statementString);
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- public boolean isNext() {
- boolean isThereNext = false;
- try {
- isThereNext = rs.next();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- return isThereNext;
- }
- public String getString(int index) {
- String res = null;
- try {
- res = rs.getString(index);
- } catch (SQLException e) {
- e.printStackTrace();
- }
- return res;
- }
- public void close() {
- try {
- con.close();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement