DAO

Dao java

public class Dao { 
	public Connection con=null;
	public ResultSet rs = null;
	public PreparedStatement stmtPrep=null; 
	public String sql;
	
	public Connection yhdista() throws Exception{
    	Connection con = null;    	        	
    	String JDBCAjuri = "org.mariadb.jdbc.Driver";
    	String url = "jdbc:mariadb://localhost:15001/a1700185";        	
   	    Class.forName(JDBCAjuri);
	    con = DriverManager.getConnection(url,"a1700185", "pass");	        
	    return con;	    
	}
	
	public void sulje() throws Exception{
		if(con!=null){			
			con.close();			
		}		
	}