locationmanager.java

This is a project used to find a corresondin location from place

package com.gecb.mcompanion.web.db;
//import com.geci.mcompanion.server.*;
import java.util.*;

import java.sql.*;
import javax.tools.JavaFileManager.Location;

public class LocationManager extends DBManager {
	private String name;
        private String des;
        private String spec;
        private String place;
        private Float lat;
        private Float  longt;
	public LocationManager() {
		super();
	}

	public boolean saveLocation1(Location location) {
		String query = "";//INSERT INTO location(name, description, speciality, address_id) VALUES ('"+location.getName()+"', '"+location.getName()+"', '"+location.getSpeciality()+"', "+location.getAddressId()+")";
		try{
			getStatement().execute(query);
			ResultSet rs =  getStatement().executeQuery("select * from location");
		} catch(Exception e) {
			e.printStackTrace();
			return false;
		}
		return true;
	}

    public boolean saveLocation(String name,String des,String spec,String place,Float lat,Float longt ){
  
            int idval = 0;
            this.name = name;
  this.des = des;
  this.spec = spec;
  this.lat = lat;
  this.longt = longt;
  this.place = place;
  try{
      
     Class.forName("com.mysql.jdbc.Driver");
  }
  catch(Exception ee){
     ee.printStackTrace();
  }
  try
  {
      Connection   con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mcompanionmarch26","root","root");
      String sqll = "select * from institution";
      Statement stmt = con.createStatement();
      ResultSet rs = stmt.executeQuery(sqll);
   if(rs.last()){
       
       idval = rs.getInt("id") +1 ;
       
   }   
      
  }
  catch(Exception e){
      e.printStackTrace();
      
  }
 
            String query = "INSERT INTO location(name,description,speciality,id,place,lat,log)VALUES('"+name+"','"+des+"','"+spec+"',"+idval+",'"+place+"',"+lat+","+longt+")";
	 try{
          Connection can = DriverManager.getConnection("jdbc:mysql://localhost:3306/mcompanionmarch26","root","root");
           
                Statement st = can.createStatement();
             st.executeUpdate(query);
             
            } 
            catch(Exception er){
             er.printStackTrace(); 
             return false;
            }
        
     return true;
           
            
        }

public ArrayList searchLocations() {
		String query = "SELECT * FROM location";
		ArrayList locationList = new ArrayList();

		try{
			ResultSet rs = getStatement().executeQuery(query);
			while(rs.next()) {
				Location location = new Location() {

                    public String getName() {
                        throw new UnsupportedOperationException("Not supported yet.");
                    }
                      public String getDescription() {
                        throw new UnsupportedOperationException("Not supported yet.");
                    }
                        public String getSpeciality() {
                        throw new UnsupportedOperationException("Not supported yet.");
                    }
                          public String getAddressId() {
                        throw new UnsupportedOperationException("Not supported yet.");
                    }
                    public boolean isOutputLocation() {
                        throw new UnsupportedOperationException("Not supported yet.");
                    }
                };
				//location.setName(rs.getString("name"));
				//location.setDescription(rs.getString("description"));
				//location.setSpeciality(rs.getString("speciality"));
				//location.setAddressId(rs.getInt("address_id"));
			//	locationList.add(location);
			}
		}catch(Exception e){
			e.printStackTrace();
		}
		return locationList;
	}
        void setName(String string) {
        throw new UnsupportedOperationException("Not yet implemented");
    }
        void setDescription(String string) {
        throw new UnsupportedOperationException("Not yet implemented");
    }
        void setSpeciality(String string) {
        throw new UnsupportedOperationException("Not yet implemented");
    }
        void setAddressId(String string) {
        throw new UnsupportedOperationException("Not yet implemented");
    }
//    public void setgetStatement()(Statement stmt) {
//        this.sgetStatement() = getStatement();
//    }
//
//    public void setConn(Connection conn) {
//        this.conn = conn;
//    }
//
//    public Connection getConn() {
//        return conn;
//    }
//
//    public Statement getgetStatement()() {
//        return getStatement();
//    }


	/*public void searchAllLocations() {
		String query = "SELECT * FROM location";
		try{
			ResultSet rs = getStatement().executeQuery(query);
			while(rs.next()) {
				System.out.println("Name :"+rs.getString("name"));
				System.out.println("Description :"+rs.getString("description"));
				System.out.println("Speciality :"+rs.getString("speciality"));
			}
		} catch(Exception e) {
			e.printStackTrace();
		}
	}*/

	/*public void searchAllLocationsByName(String name) {
		String query = "SELECT * FROM location where name='"+name+"'";
		try{
			ResultSet rs = getStatement().executeQuery(query);
			while(rs.next()) {
				System.out.println("Name :"+rs.getString("name"));
				System.out.println("Description :"+rs.getString("description"));
				System.out.println("Speciality :"+rs.getString("speciality"));
			}
		} catch(Exception e) {
			e.printStackTrace();
		}
	}*/

	/*public void searchAllLocationsByDescription(String description) {
		String query = "SELECT * FROM location where description='"+description+"'";
		try{
			ResultSet rs = getStatement().executeQuery(query);
			while(rs.next()) {
				System.out.println("Name :"+rs.getString("name"));
				System.out.println("Description :"+rs.getString("description"));
				System.out.println("Speciality :"+rs.getString("speciality"));
			}
		} catch(Exception e) {
			e.printStackTrace();
		}
	}*/

	public void searchAllLocationsBySpeciality(String speciality) {
		String query = "SELECT * FROM location where speciality='"+speciality+"'";
		try{
			ResultSet rs = getStatement().executeQuery(query);
			while(rs.next()) {
				System.out.println("Name :"+rs.getString("name"));
				System.out.println("Description :"+rs.getString("description"));
				System.out.println("Speciality :"+rs.getString("speciality"));
			}
		} catch(Exception e) {
			e.printStackTrace();
		}
	}

	public static void main(String[] args) {
		//new LocationManager().searchAllLocations();
		//new LocationManager().searchAllLocationsByName("Pattom");
            //new LocationManager().searchAllLocationsByDescription("Pattom Desc");
              new LocationManager().searchAllLocationsBySpeciality("Speciality of Pattom");



	}
}