Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.io.IOException;
- import java.sql.*;
- import java.util.ArrayList;
- /**
- * Created by Natan on 23.10.2016..
- */
- public class Practice
- {
- static String mysql = "jdbc:mysql://localhost:3306/travel?autoReconnect=true&useSSL=false";
- static String username = "root";
- static String password = "student";
- Connection conn;
- boolean var;
- public Practice(String mysql, String username, String password)
- {
- this.mysql = mysql;
- this.username = username;
- this.password = password;
- }
- public boolean connect()
- {
- boolean var = false;
- try
- {
- conn = DriverManager.getConnection(mysql, username, password);
- if(conn == null)
- {
- var = false;
- }
- else
- {
- var = true;
- }
- }
- catch(SQLException sqle)
- {
- System.out.println("fdssdf");
- }
- return var;
- }
- public boolean close()
- {
- boolean var = false;
- try
- {
- conn.close();
- if(conn.isClosed())
- {
- System.out.println("Connection closed");
- var = true;
- }
- else
- {
- System.out.println("Connection not closed");
- var = false;
- }
- }
- catch(SQLException sqle)
- {
- }
- return var;
- }
- public ArrayList<Student> getData(String sql)
- {
- ArrayList<Student> list = null;
- int passengerid = 0;
- String fname = null;
- String lname = null;
- try
- {
- Statement statement = conn.createStatement();
- ResultSet rs = statement.executeQuery(sql);
- while(rs.next())
- {
- passengerid = rs.getInt(1);
- fname = rs.getString(2);
- lname = rs.getString(3);
- }
- System.out.println("PassengerID " + passengerid + "\n");
- System.out.println("PassengerID " + fname + "\n");
- System.out.println("PassengerID " + lname + "\n");
- }
- catch(SQLException sqle)
- {
- }
- return list;
- }
- public static void main(String[] args)
- {
- Practice obj = new Practice(mysql, username, password);
- obj.connect();
- System.out.println("Connected");
- obj.close();
- }
- }
Add Comment
Please, Sign In to add comment