Connection con = null;
    PreparedStatement stmt = null;
    ResultSet rs = null;
    StringBuffer query = null;
    try
    {
        Class.forName("com.mysql.jdbc.Driver");
        String serverName = "localhost";
        String mydatabase = "application";
        String url = "jdbc:mysql://" + serverName + "/" + mydatabase; // a JDBC url
        url += "?useUnicode=true&characterEncoding=Cp1254";
        String username = "root";
        String password = "";
        con = DriverManager.getConnection(url, username, password);
		query = new StringBuffer();
		query.append("SELECT * FROM urunler ORDER BY ID desc");
		stmt = con.prepareStatement(query.toString());
		rs = stmt.executeQuery();